Full DB Export from 8i and Import into 10g
i am trying to export full db (8i) into 10g db
at 8i machine which has two schemas (NCL,NCL_TEST)
exp system/gateway@8i_db file=c:\fullbackup.dmp full=y
Export terminated Successfully
and then i copied the dumpfile to destination 10g DB machine
At 10g Machine
and when i try to import the database with the following
imp system/gateway@10g_db file=c:\fullbackup.dmp full=y log=c:\log1.log
Import is terminated with warning
I also have attached log file which contains enterires like
User "NCL" does not exist
User "NCL_TEST" does not exist
Can u please look at the log file i have attached
May be i am wrong but i think we don't need to create users at the destination DB if we are using full import
i also have the same tablespaces in both 8i and 10g DB
I am doing an export at 8i machine and trying to import at 10g machine locally
Can anybody please help me in this regard?
thanx in advance
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "NCL" IDENTIFIED BY VALUES '3092CC82C735C5A2' DEFAULT TABLESPAC"
"E "WIZDATA" TEMPORARY TABLESPACE "TEMP_WIZERP_DATA""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TEMP_WIZERP_DATA' does not exist
Originally Posted by xyz2000
Ok i got it and now i'll try it again
but thanx a lot for ur prompt response
Also take care about privileges assigned to those two users. All the object and System privileges.
Click Here to Expand Forum to Full Width