Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SP2-0734: unknown command beginning "impdp"

Need Help ..

i am Importing a .DMP file on my database , when i am writing my impdp query on SQL , it is returning with this error I have no idea what this error is

SP2-0734: unknown command beginning "impdp ... " Rest of the line ignored

my command is

impdp user/pass directory=DUMPS dumpfile=filedumpname.dmp logfile=name.log full=yes
like image 327
Hamza Nawaz DBA Avatar asked Apr 29 '13 06:04

Hamza Nawaz DBA


2 Answers

SP2-0734 is a SQL*Plus error.

impdp is a standalone utility, not a SQL*Plus command. You need to run it from the OS command line.

-- This means that impdp is Windows command, not part of sqlplus :-) --

like image 135
Marco Baldelli Avatar answered Oct 17 '22 17:10

Marco Baldelli


This error is produced because impdp is not an SQLPlus command.

Resolved

If you try to run this as a sqlplus command, you get an error:

C:\Windows\system32>sqlplus sys/oracle@orcl as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Nov 7 12:03:56 2018

Copyright (c) 1982, 2017, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> impdp system/oracle@orcl directory=dp schemas=SCDB dumpfile=SCDB.DMP logfile=SCDB.log  

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


Indeed, you have to open a new terminal and run the command there:

C:\Windows\system32>impdp system/oracle@orcl directory=dp schemas=SCDB dumpfile=SCDB.DMP logfile=SCDB.log

Import: Release 12.2.0.1.0 - Production on Wed Nov 7 12:10:48 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
like image 20
Md. Ilyas Hasan Mamun Avatar answered Oct 17 '22 17:10

Md. Ilyas Hasan Mamun