Primavera (MOSC)

MOSC Banner

How to use Data Pump to backup and restore all my Oracle Primavera Data base? I just want to expdp a

edited Mar 18, 2013 8:13AM in Primavera (MOSC) 5 commentsAnswered
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';

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center