OraFAQ Forum: Server Utilities » Importing a schema from 9i to 10g using data pump import export + errors :(

Home » RDBMS Server » Server Utilities » Importing a schema from 9i to 10g using data pump import export + errors :(

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Importing a schema from 9i to 10g using data pump import export + errors :( [message #299548]

Tue, 12 February 2008 07:14

oraclewannabe
Messages: 26
Registered: January 2008

Junior Member

hi i am using oracle 10g express now. my friend had exported a schema from oracle 9i and i want to load the schema into my new database.
the exported filename is grsv.exp and i have put it at my desktop

i have read the 10x documentation at http://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/impexp.htm#BCEEDCIB
i went to try the sample instructions in the documentation with import and export using expdp and impdp, but i always get this error in the sql command prompt

SQL> expdp SYSTEM/password SCHEMAS=hr DIRECTORY=dmpdir DUMPFILE=schema.dmp LOGFILE=expschema.log
SP2-0734: unknown command beginning "expdp...." - rest of line ignored

1) can i know what wrong ? what should i do ?

2) what utility should i use to load a schema from oracle 9i to 10ex ? how do i do it ?

[Updated on: Tue, 12 February 2008 07:17]

Report message to a moderator

Re: Importing a schema from 9i to 10g using data pump import export + errors :( [message #299549 is a reply to message #299548]

Tue, 12 February 2008 07:20

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi,

Oracle 9i does not have expdp. This is announced in 10g.

You need to export with exp Version 9i and import with imp Version 10g.
Do not mix up exp and impdp, because the dumpfile from exp is not readable with impdp

Another tip:

export/import and expdp / impdp are not SQL-commands. They are shell commands. So do not run them in SQLPLUS.

regards
Uwe

[Updated on: Tue, 12 February 2008 07:21]

Report message to a moderator