OraFAQ Forum: Server Utilities » Error executing 'Impdp' utility

Home » RDBMS Server » Server Utilities » Error executing 'Impdp' utility (Oracle 11g)

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

Error executing 'Impdp' utility [message #570439]

Fri, 09 November 2012 10:11

kamu711
Messages: 4
Registered: November 2012
Location: Accra, Ghana

Junior Member

I exported three databases : servicedesk, report and mostcmdb on server A to a dumpfile. Moved them to similar dump location on server B. Now, I want to import them into B by using:

[SQL> impdp system/OSS_MOS7100 dumpfile=MOSTCMDB_0211.DMP schemas=mostcmdb

The error was:

SP2-0734: unknown command beginning "impdp syst..." - rest of line ignored.

Any help? what can i do?

Report message to a moderator

Re: Error executing 'Impdp' utility [message #570440 is a reply to message #570439]

Fri, 09 November 2012 10:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

what is Operating System name & version?
which OS user is logged onto the OS & invoking impdp?

Report message to a moderator

Re: Error executing 'Impdp' utility [message #570445 is a reply to message #570439]

Fri, 09 November 2012 11:46

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

You are trying to run the impdp utility from within a SQL*Plus session. Run it from an OS prompt, just as you did when you ran expdp.

Report message to a moderator

Re: Error executing 'Impdp' utility [message #570767 is a reply to message #570440]

Thu, 15 November 2012 10:24

kamu711
Messages: 4
Registered: November 2012
Location: Accra, Ghana

Junior Member

Sorry, I was away on some urgent issues.

OS: Windows Server 2003 Standard Edition (5.2, build 3790)
DirectX version:DirectX 9.0c (4.09.0000.0904)

the OS user logged on and invoking "impdp" was: 'system'
Thanks.

Report message to a moderator

Re: Error executing 'Impdp' utility [message #570768 is a reply to message #570767]

Thu, 15 November 2012 10:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> host impdp system/OSS_MOS7100 dumpfile=MOSTCMDB_0211.DMP schemas=mostcmdb

Report message to a moderator

Re: Error executing 'Impdp' utility [message #570769 is a reply to message #570445]

Thu, 15 November 2012 10:32

kamu711
Messages: 4
Registered: November 2012
Location: Accra, Ghana

Junior Member

the Expdp was ran from the same SQL*Plus session and it worked as follows:

SQL>Expdp system/OSS_MOS7100 dumpfile=mostcmdb_XXXX.dmp schemas=mostcmdb logfile=mos7100.log
Thaks

Report message to a moderator

Re: Error executing 'Impdp' utility [message #570770 is a reply to message #570769]

Thu, 15 November 2012 10:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

kamu711 wrote on Thu, 15 November 2012 08:32

the Expdp was ran from the same SQL*Plus session and it worked as follows:

SQL>Expdp system/OSS_MOS7100 dumpfile=mostcmdb_XXXX.dmp schemas=mostcmdb logfile=mos7100.log
Thaks

I don't believe you.

Report message to a moderator

Re: Error executing 'Impdp' utility [message #570771 is a reply to message #570767]

Thu, 15 November 2012 11:11

kamu711
Messages: 4
Registered: November 2012
Location: Accra, Ghana

Junior Member

It worked like magic.
Thanks a lot BlackSwan.
Have a nice day

Regards,
Kamu711

Report message to a moderator

Previous Topic:	Procedures, triggers and other object with character changed.
Next Topic:	IMPDP errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 18:28:40 CST 2025