Probém:

oracle@ORACLE2:/data/TEST$ impdp \'/ as sysdba\' schemas=OPER directory=DATA_PUMP_DIR TABLE_EXISTS_ACTION=TRUNCATE dumpfile=full.dmp logfile=imp.log
Import: Release 10.2.0.1.0 - 64bit Production on Friday, 29 September, 2017 11:58:51
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.1.0 - 64bit Production

UDI-00008: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 911
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2896
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3789
ORA-06512: at line 1

Řešení

ORA-00604 ORA-01422 When Trying To Drop A Table (Doc ID 453528.1)

SQL> select * from my_dual;
D
-
X
X

SQL> create table my_dual as select * from dual;
Table created.

SQL> select * from my_dual;
D
-
X
X

SQL> delete from dual where dummy = 'X' and rownum=1;
1 row deleted.

SQL> commit;
Commit complete.

SQL> select * from dual;
D
-
X


Komentáře