Home » RDBMS Server » Server Utilities » Import error
Import error [message #131672] Mon, 08 August 2005 21:40 Go to next message
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
Senior Member
Dears

I want to import the exported file from Oracle 9.2.0.1 into oracle 8.1.6. It is giving me the error IMP-00010.

Is it that i can not import the file exported from the higher version in oracle?? If not, then give me the solution for the same. If yes, then what i have to do to minimize my work.

It is urgent.

Samit Gandhi

Report message to a moderator

Re: Import error [message #131674 is a reply to message #131672] Mon, 08 August 2005 22:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use lower version of imp to import.
else
run catexp.sql of higherversion against the lower version.
from 9i machine login as sys to the 8i database.
run $ORACLE_HOME/rdbms/admin/catexp.sql

Report message to a moderator

Re: Import error [message #131678 is a reply to message #131674] Mon, 08 August 2005 22:42 Go to previous message
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
Senior Member
I am using the OS Windows2000. What is the procedure i have to do give me in detail.

I am a new in this field having no much database administration knowledge.

Samit Gandhi

Report message to a moderator

Previous Topic: Oracle Management Server Installation
Next Topic: sql loader mapping only specific columns from data file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 05:35:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.