 Import dump into my Ubuntu 6.06 Oracle 10g DB [message #182698] |
Mon, 17 July 2006 11:16  |
stockton
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 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - 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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
