Home » RDBMS Server » Server Utilities » Schema impdb invalid statement error (10.2.0.4.0 on Window 2008 64 bit)
Schema impdb invalid statement error [message #455473] Tue, 11 May 2010 12:50 Go to next message
estolts
Messages: 6
Registered: April 2009
Location: San Antonio
Junior Member
I am trying to import a schema backup using sqldeveloper and getting this syntax error:
ORA-00900: invalid SQL statement

Here is the import statement:
impdp sys/*****@ccpsp schemas=ccpsp_staging directory=dmpdir DUMPFILE=CCPSP_USERCCPSP_STAGINGSCHEMABACKUP_07MAY2010.dmp LOGFILE=IMPDP_CCPSPStagingSchemaImport.log;

Where am I or the statement going bad?
Re: Schema impdb invalid statement error [message #455474 is a reply to message #455473] Tue, 11 May 2010 12:58 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the whole log.

Regards
Michel
Re: Schema impdb invalid statement error [message #455475 is a reply to message #455473] Tue, 11 May 2010 12:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I am trying to import a schema backup using sqldeveloper
impdp has NOTHING to do with sqldeveloper.

impdp needs to be run from OS command line
Re: Schema impdb invalid statement error [message #455480 is a reply to message #455475] Tue, 11 May 2010 14:41 Go to previous message
estolts
Messages: 6
Registered: April 2009
Location: San Antonio
Junior Member
Tks. That was the trick.
Previous Topic: importing table data is not comming
Next Topic: Import/export Log file
Goto Forum:
  


Current Time: Fri Sep 17 09:12:40 CDT 2021