Home » RDBMS Server » Server Utilities » Importing a schema from 9i to 10g using data pump import export + errors :(
Importing a schema from 9i to 10g using data pump import export + errors :( [message #299548] Tue, 12 February 2008 07:14 Go to next message
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 Go to previous messageGo to next message
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

Re: Importing a schema from 9i to 10g using data pump import export + errors :( [message #299550 is a reply to message #299548] Tue, 12 February 2008 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) expdb is an OS program not a SQL*Plus command
2) You have to use imp to import 9i database, you can't use impdp

Regards
Michel
Re: Importing a schema from 9i to 10g using data pump import export + errors :( [message #299909 is a reply to message #299548] Wed, 13 February 2008 10:48 Go to previous message
oraclewannabe
Messages: 26
Registered: January 2008
Junior Member
Surprised sorry my mistake
Previous Topic: imp a schema from oracle 9i Mac to Oracle 9i XP
Next Topic: Problem: Import Bulk database in 8i to 10g
Goto Forum:
  


Current Time: Sun Dec 04 23:12:30 CST 2016

Total time taken to generate the page: 0.12030 seconds