full database import
Hi,
I am trying to import a full database using the impdp method.
impdp system/oracle dumpfile=datap:fulldb.dmp full=y logfile=datap:full.log
I am getting fatal error message while importing.
===========================
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6273
----- PL/SQL Call Stack -----
object line object
handle number name
5e6414d4 14916 package body SYS.KUPW$WORKER
5e6414d4 6300 package body SYS.KUPW$WORKER
5e6414d4 12689 package body SYS.KUPW$WORKER
5e6414d4 11968 package body SYS.KUPW$WORKER
5e6414d4 3279 package body SYS.KUPW$WORKER
5e6414d4 6889 package body SYS.KUPW$WORKER
5e6414d4 1262 package body SYS.KUPW$WORKER
6408cfd0 2 anonymous block
Job "SYSTEM"."SYS_IMPORT_FULL_03" stopped due to fatal error at 13:19:32:
==================================
My question is 'should we have to create all the tablespaces(other than system tablespaces) that was available in the primary database manually in the target machine before executing the import command?
What are the prerequisites for importing a full export into a database? How do we make the target database ready to accept the import?
my oracle version is 10.2.0 on solaris 10
Thanks in advance....
Edited by: user13364377 on 24-Jul-2010 14:33