首页 > Linux操作系统 > Linux操作系统 > 转载:请教关于dual表的问题


原创 Linux操作系统 作者:lfree 时间:2005-04-24 00:00:00 0 删除 编辑

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.

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。


  • 博文量
  • 访问量