-
[oracle@apex ~]$ imp file=ash.dmp fromuser=sys touser=a
-
-
Import: Release 19.0.0.0.0 - Production on Thu Nov 25 14:51:25 2021
-
Version 19.10.0.0.0
-
-
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
-
-
Username: / as sysdba
-
-
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
-
Version 19.10.0.0.0
-
-
Export file created by EXPORT:V11.02.00 via conventional path
-
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
-
export client uses US7ASCII character set (possible charset conversion)
-
IMP-00403:
-
-
Warning: This import generated a separate SQL file "import_sys" which contains DDL that failed due to a privilege issue.
-
-
. importing SYS's objects into A
-
. . importing table "ASH1126"
-
IMP-00058: ORACLE error 604 encountered
-
ORA-00604: error occurred at recursive SQL level 1
- ORA-04088: error during execution of trigger 'LBACSYS.LBAC$AFTER_DROP
alter trigger LBACSYS.LBAC$AFTER_DROP disable;
重新导入
-
[oracle@apex ~]$ imp file=ash.dmp fromuser=sys touser=a
-
-
Import: Release 19.0.0.0.0 - Production on Thu Nov 25 14:52:51 2021
-
Version 19.10.0.0.0
-
-
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
-
-
Username: / as sysdba
-
-
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
-
Version 19.10.0.0.0
-
-
Export file created by EXPORT:V11.02.00 via conventional path
-
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
-
export client uses US7ASCII character set (possible charset conversion)
-
IMP-00403:
-
-
Warning: This import generated a separate SQL file "import_sys" which contains DDL that failed due to a privilege issue.
-
- . importing SYS