How to use Data Pump to backup and restore all my Oracle Primavera Data base? I just want to expdp a
How to use Data Pump to backup and restore all my Oracle Primavera Data base?
I did on my database as system dba
create directory BKFOLDER as 'c:/backup/export';
I did on my database as system dba
create directory BKFOLDER as 'c:/backup/export';
expdp system/Prima123Vera DIRECTORY=BKFOLDER DUMPFILE=bkob1ob2.dmp full=y
Then on other database I did
create directory BKFOLDER as 'c:/backup/export';
impdp system/Prima123Vera DIRECTORY=BKFOLDER DUMPFILE=bkob1ob2.DMP full=y
Then at the end I saw log import log file and there are 8068 warning or error, but I decided to login from P6 Client and there were all my projects,
I ran a validate and did not show error on the html file. All my data is ok. But I would like to expdp only the tablespace or my pmdb database and impdp
0