个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2021-11-26 06:57:30
好久不用imp，今日从11.2.0.4取了一个dba_hist_active_sess_history 时：
似乎和标签安全有关，先禁用
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:51:25 2021
-
version 19.10.0.0.0
-
-
凯发app官方网站 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
-
-
凯发app官方网站 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
给主人留下些什么吧！~~