imp00017由于Oracle错误ORA-01401的解决办法

2014-11-24 17:22:07 · 作者: · 浏览: 0

Total System Global Area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 1006636376 bytes
Database Buffers 637534208 bytes
Redo Buffers 7118848 bytes
Database mounted.
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;


System altered.


SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;


System altered.


SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;


System altered.


SQL> ALTER DATABASE OPEN;


Database altered.


SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;


Database altered.


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.


Total System Global Area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 1006636376 bytes
Database Buffers 637534208 bytes
Redo Buffers 7118848 bytes
Database mounted.
Database opened.
SQL>


最后客户端导入成功


imp00017由于Oracle错误ORA-01401的解决办法