![]() Step 5: Take export using expdp and give clause full=Y u01]$ expdp directory=bkp dumpfile=hra_23082018.dmp logfile=hra_23082018.log full=yĮxport: Release 12.2.0.1.0 - Production on Mon Aug 27 21:51:26 2018Ĭopyright (c) 1982, 2017, Oracle and/or its affiliates. Step 4: Grant necessary privileges to the user with whom you want to take backup : SQL> grant read, write on directory bkp to hra ![]() (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) Step 3: Create tns entry in tnsnames.ora for the pluggable database if not already done : orclpdb = Step 2: Create a directory for data pump export : SQL> create directory bkp as '/u01/' Step 1: Connect to pdb from where you want to take export : SQL> alter session set container = orclpdb In this post, we will see how we can take an export from one pdb and import into another pdb.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |