The table DUAL is deleted in migrate.bsq when running the Migration Utility.
Solution: ——— You need to manually create table DUAL by running the following scripts connected as SYS:
SVRMGR> connect SYS/password
SVRMGR> drop public synonym dual;
SVRMGR> create table dual (dummy varchar2(1))
2> storage (initial 1);
SVRMGR> insert into dual values(‘X’);
1 row processed.
SVRMGR> create public synonym dual for dual;
Statement processed. SVRMGR> grant select on dual to public
2> with grant option;
After creating the table DUAL, the catalog.sql and catproc.sql scripts must be rerun.
The table DUAL is referenced in the package body for STANDARD in the script $ORACLE_HOME/rdbms/admin/standard.sql, which is called when catproc.sql is run. The table does not exist because it was dropped by the Migration Utility.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-82775/，如需转载，请注明出处，否则将追究法律责任。