1 Attachment(s)
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
