1. 首页
  2. IT资讯

转载:请教关于dual表的问题

出自: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.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267265/viewspace-82775/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:深沉的少年,转转请注明出处:http://www.cxybcw.com/183054.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code