Home » Infrastructure » Linux » Import dump into my Ubuntu 6.06 Oracle 10g DB
icon5.gif  Import dump into my Ubuntu 6.06 Oracle 10g DB [message #182698] Mon, 17 July 2006 11:16 Go to next message
Messages: 10
Registered: July 2005
Location: South Africa
Junior Member
I need to import an Oracle 9i dump made on a Windows system into my 10g database and I have attempted using the following command:-

imp userid=usr/passwd full=y file=/media/cdrom0/alf/cards_members.dmp ignore=y log=cards_members.log buffer=10000000

However this fails with ORA-00900: invalid SQL statement

The log from the creation of the dump file was:-

Connected to: Oracle9i Enterprise Edition Release - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release - Production

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...

. . exporting table MEMBERS 162301 rows exported

. . exporting table CARDS 168730 rows exported

Export terminated successfully without warnings.

Please make helpful suggestions on how to do this import.
I am using sql->sql on apex.
Re: Import dump into my Ubuntu 6.06 Oracle 10g DB [message #182737 is a reply to message #182698] Mon, 17 July 2006 21:07 Go to previous message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please post the complete command line of the "export".
exp & imp do/did have bugs that are version dependent;
9i & 10g are marketing names NOT version identifiers.
Why are you imp full=y?
Previous Topic: Listener Problem on Suse 9.3 and Oracle 10g
Next Topic: Invalid Staging Area when installing 10g R2
Goto Forum:

Current Time: Tue May 28 09:20:35 CDT 2024