出自：http://www.itpub.net/351775,2.html
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;
Statement processed.
SVRMGR> create table dual (dummy varchar2(1))
2> storage (initial 1);
Statement processed.
SVRMGR> insert into dual values('X');
1 row processed.
SVRMGR> commit;
Statement processed.
SVRMGR> create public synonym dual for dual;
Statement processed. SVRMGR> grant select on dual to public
2> with grant option;
Statement processed.
After creating the table DUAL, the catalog.sql and catproc.sql scripts must be rerun.
SVRMGR> @?/rdbms/admin/catalog.sql
SVRMGR> @?/rdbms/admin/catproc.sql
Solution Explanation:
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.
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;
Statement processed.
SVRMGR> create table dual (dummy varchar2(1))
2> storage (initial 1);
Statement processed.
SVRMGR> insert into dual values('X');
1 row processed.
SVRMGR> commit;
Statement processed.
SVRMGR> create public synonym dual for dual;
Statement processed. SVRMGR> grant select on dual to public
2> with grant option;
Statement processed.
After creating the table DUAL, the catalog.sql and catproc.sql scripts must be rerun.
SVRMGR> @?/rdbms/admin/catalog.sql
SVRMGR> @?/rdbms/admin/catproc.sql
Solution Explanation:
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.
