ORA-04088 LBACSYS.LBAC_EVENTS

好久不用imp，今日从11.2.0.4取了一个dba_hist_active_sess_history 时：

[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