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
Attached Files
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
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
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.
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width