ORA-18008: cannot find OUTLN schema

来源：互联网发布：linux 内网代理上网编辑：程序博客网时间：2024/05/16 07:34

因导出总个数据库后，在导入时总是很多错误，看了一文件：
http://yangtingkun.itpub.net/post/468/216265
其中有此代码：
DROP USER ANONYMOUS CASCADE;
DROP USER OUTLN CASCADE;
DROP USER WMSYS CASCADE;
DROP USER ORDSYS CASCADE;
DROP USER ORDPLUGINS CASCADE;
DROP USER MDSYS CASCADE;
DROP USER CTXSYS CASCADE;
DROP USER XDB CASCADE;
DROP USER WKSYS CASCADE;
DROP USER WKPROXY CASCADE;
DROP USER ODM CASCADE;
DROP USER ODM_MTR CASCADE;
DROP USER OLAPSYS CASCADE;
DROP USER HR CASCADE;
DROP USER OE CASCADE;
DROP USER PM CASCADE;
DROP USER SH CASCADE;
DROP USER QS_ADM CASCADE;
DROP USER QS CASCADE;
DROP USER QS_WS CASCADE;
DROP USER QS_ES CASCADE;
DROP USER QS_OS CASCADE;
DROP USER QS_CBADM CASCADE;
DROP USER QS_CB CASCADE;
DROP USER QS_CS CASCADE;

还没运行完，突然发现，服务器错误了，提示：ORA-18008: cannot find OUTLN schema
这下死了。

后一看到
http://seagull76.itpub.net/post/29088/270104
说可以运行以下代码：

1)conn / as sysdba

2)create user outln identified outln;

3)grant connect,resource to outln;

4)exec dbms_outln_edit.create_edit_tables();

重新建立用户OUTLN。但不成功，

提示错误：

ORA-00604: error occurred at recursive SQL level 1

ORA-18008: cannot find OUTLN schema

越做越忙了。：（
我想再用以前的DMP 再导回去了。55555555555555555。。。。。