SP2-0734: unknown start of the "impdp" command

Question

Need help..

I am importing a .DMP file in my database, when I write my impdp query in SQL, it returns with this error I don’t know what kind of error it is

SP2-0734: Unknown start of "impdp ..." command The rest of the line is ignored

my team

 impdp user/pass directory=DUMPS dumpfile=filedumpname.dmp logfile=name.log full=yes 

Answer 1

SP2-0734 - 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 a Windows command, not part of sqlplus :-) -

Answer 2

This error occurs because impdp not a SQLPlus command.

Solved

 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. SQL> ^C 

 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 

Answer 3

I tried all the methods, but finally, I realized that we should change the encoding to ANSI for all files (.pck, .tps, .typ, .fnc). Hope this helps you;)