Posted by
Arsalan on
Dec 10, 2019; 7:13am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Impdp-problem-tp7897p7904.html
Hi Arslan
1-- I run below script to take full expdp backup it successfuly completed
system/********@prod DIRECTORY=DUMPFILE dumpfile=Prod-12-04-2019.dmp logfile=prod-12-04-2019.log full=y
2-I copied dumpfile to oracle 12c pluggable database server
3-I Created same tablespaces in pluggable database as Source oracle 11g 11.2.0.4 have
login to ORACLE 12C PLUGGABLE DB
4-set oracle_sid=pdb1
sys/aone@pdb1 as sysdba
Connected.
I create directory p6_dir as 'c:\app\arsala\p6_dir'; on pluggable database
grant read,write on directory p6_dir to system;
----Grant priviliges to SYSTEM USER TO IMPORT DUMPFILE
GRANT DBA,BECOME USER,CREATE ANY JOB,CREATE EXTERNAL JOB,DEQUEUE ANY QUEUE,ENQUEUE ANY QUEUE,EXECUTE ANY CLASS,EXECUTE ANY PROGRAM,MANAGE ANY QUEUE,
MANAGE SCHEDULER,SELECT ANY TRANSACTION,IMP_FULL_DATABASE TO SYSTEM;
then i run impdp command like below
impdp system/********@pdb1 DIRECTORY=p6_dir DUMPFILE=AFGPROD-08-26-2019.DMP logfile=SIGFINALE1.log FULL=Y
I found the error please find to log file for details
SIGFINALE1.logplease guide me