OraFAQ Forum: Server Utilities » Schema impdb invalid statement error

Home » RDBMS Server » Server Utilities » Schema impdb invalid statement error (10.2.0.4.0 on Window 2008 64 bit)

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

Schema impdb invalid statement error [message #455473]

Tue, 11 May 2010 12:50

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?

Report message to a moderator

Re: Schema impdb invalid statement error [message #455474 is a reply to message #455473]

Tue, 11 May 2010 12:58

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post the whole log.

Regards
Michel

Report message to a moderator

Re: Schema impdb invalid statement error [message #455475 is a reply to message #455473]

Tue, 11 May 2010 12:59

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

Report message to a moderator

Re: Schema impdb invalid statement error [message #455480 is a reply to message #455475]

Tue, 11 May 2010 14:41

estolts
Messages: 6
Registered: April 2009
Location: San Antonio

Junior Member

Tks. That was the trick.

Report message to a moderator

Previous Topic:	importing table data is not comming
Next Topic:	Import/export Log file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 21:19:18 CDT 2024