转载:请教关于dual表的问题
更新时间:2021-08-16 16:16:49
出自: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.