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 388 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
Messages: 43
Registered: December 2006
"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: reinstall oracle10g
Next Topic: Temporary tablespace VS Temporary datafile question
Goto Forum:

Current Time: Sun Aug 20 20:00:54 CDT 2017

Total time taken to generate the page: 0.24836 seconds