imp
okman312
底层it工作者
展开
-
imp报错Warning: This import generated a separate SQL file “fx_sys.sql“ which contains DDL that failed
[oracle@oracle04 ~]$imp fx/fx file=fx.dmp log=fx.log rows=n full=yImport: Release 12.2.0.1.0 - Production on Mon Nov 2 07:23:05 2020Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 12c Enterp原创 2020-11-02 07:26:03 · 2907 阅读 · 1 评论 -
imp导入报错IMP-00013: only a DBA can import a file exported by another DBA
报错:IMP-00013: only a DBA can import a file exported by another DBA提示导入的用户要有DBA权限;授权再导入[oracle@oracle04 ~]$sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Mon Nov 2 07:08:02 2020Copyright (c) 1982, 2016, Oracle. All rights reserved.原创 2020-11-02 07:11:51 · 633 阅读 · 0 评论