| Full DB Export from 8i and Import into 10g [message #209627] |
Sat, 16 December 2006 00:41  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
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?
-
Attachment: log1.txt
(Size: 15.72KB, Downloaded 1530 times)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
