Primavera (MOSC)

MOSC Banner

Error when importing an Oracle xe dmp

edited Aug 28, 2016 9:40PM in Primavera (MOSC) 2 commentsAnswered ✓

1- I already created a back up of a P6 EPPM rel. 8.3.2 datanase in Oracle xe and now I want to restore it in a freshly installed Oracle xe:

2- in the freshly installed Oracle XE, I run "before_import_8x" explained in How to Backup/Restore an Oracle Express (XE) Database? (Doc ID 914116.1)

2- After successfully running the mentioned script, I run "imp userid=system/<password>@xe file=<path>\xedump.dmp commit=y buffer=8000000 fromuser=(admprm$pm,privprm$pm,pubprm$pm,bgjob$pm) touser=(admprm$pm,privprm$pm,pubprm$pm,bgjob$pm) log=<path>\imp_xedump.log" as again said in the mentioned doc.

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