Home » RDBMS Server » Server Administration » Full DB Export from 8i and Import into 10g
Full DB Export from 8i and Import into 10g [message #209627] Sat, 16 December 2006 00:41 Go to next message
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 349 times)
Re: Full DB Export from 8i and Import into 10g [message #209641 is a reply to message #209627] Sat, 16 December 2006 04:46 Go to previous message
dba_blr
Messages: 43
Registered: December 2006
Member
"O/S-Error: (OS 3) The system cannot find the path specified."

This means import is trying to create your tablespaces but the path it is looking for does not exist.

So you better rectify these first and try to run import again. You do not need to create users and tablepaces beforehand.


[Updated on: Sat, 16 December 2006 04:49]

Report message to a moderator

Previous Topic: INSTANCE_NAME change
Next Topic: Table size in Oracle 9i
Goto Forum:
  


Current Time: Tue Dec 06 00:05:40 CST 2016

Total time taken to generate the page: 0.07406 seconds