Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMPDP in pluggable database

Raghav_DBAAug 6 2018 — edited Oct 15 2018

I created pluggable database

SQL> create pluggable database TESTPDB1 admin user TESTPDB identified by testpdb1 create_file_dest='C:\app\raghavb\oradata\testcdb';

Pluggable database created.

SQL> alter pluggable database TESTPDB1 open;

Pluggable database altered.

SQL> select pdb_name,con_id from dba_pdbs;

PDB_NAME CON_ID

-------------------------------------------------------------------------------------------------------------------------------- ----------

TESTPDB 3

PDB$SEED 2

TESTPDB1 4

SQL> select file_name from cdb_data_files where con_id=4;

FILE_NAME

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

C:\APP\RAGHAVB\ORADATA\TESTCDB\TESTCDB\24D83B20B06045008BB1160AC1CCE071\DATAFILE\O1_MF_SYSTEM_FPJFVLR0_.DBF

C:\APP\RAGHAVB\ORADATA\TESTCDB\TESTCDB\24D83B20B06045008BB1160AC1CCE071\DATAFILE\O1_MF_SYSAUX_FPJFVLRH_.DBF

SQL> alter session set container = TESTPDB1;

Session altered.

SQL> show con_id;

CON_ID

------------------------------

4

SQL> create directory PUGDIR as 'C:\app\raghavb\PUMP';

Directory created.

SQL> grant read, write on directory PUGDIR to testpdb;

Grant succeeded.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

C:\Windows\system32>impdp system/manager@TESTPDB1 directory=PUGDIR dumpfile=EXPDB.DMP tablespaces=DEVELOPMENT

Import: Release 12.1.0.2.0 - Production on Mon Aug 6 17:34:34 2018

Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.

UDI-12154: operation generated ORACLE error 12154

ORA-12154: TNS:could not resolve the connect identifier specified

pastedImage_20.png

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2018
Added on Aug 6 2018
15 comments
24,337 views