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