手动创建库后,sys用户查询dba_tablespaces报错:ORA-00942: table or view does not exist
来源:互联网 发布:mac预览编辑pdf 编辑:程序博客网 时间:2024/05/16 05:47
在使用脚本创建数据库后,使用sys用户查询dba_tablespaces视图,报ORA-00942: table or view does not exist
正常情况下创建完数据库后数据字典就已经创建完成了啊,于是重新跑创建数据字典的脚本
>@?/rdbms/admin/catalog.sql
再次查询,还是报错
检查是否有无效对象
>@?/rdbms/admin/utlrp.sql
自带的包调用报错,于是怀疑是否是PL/SQL的相关脚本创建失败--catproc.sql
执行该脚本
>@?/rdbms/admin/catproc.sql
执行结束后,再次查询
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS
终于正常!
0 0
- 手动创建库后,sys用户查询dba_tablespaces报错:ORA-00942: table or view does not exist
- ORA-00942:table or view does not exist
- ORA-00942: table or view does not exist
- ORA-00942:table or view does not exist
- ORA-00942: table or view does not exist
- “ORA-00942 : table or view does not exist ”
- ORA-00942: table or view does not exist
- ORA-00942: table or view does not exist
- ORA-00942:table or view does not exist
- PL/SQL: ORA-00942: table or view does not exist
- ORA-00942 Table or View Does Not Exist Oracle Error
- ORA-00942 table or view does not exist
- ORA-00942: table or view does not exist
- Create Table Space (Ora-00942 error:table or view does not exist)
- Create Table Space (Ora-00942 error:table or view does not exist)
- 还有一种情况会出现 ORA-00942:table or view does not exist
- ASP.NET MVC - Entity Framework - Oracle - ORA-00942: table or view does not exist
- rep进程删不掉-OCI Error ORA-00942: table or view does not exist (status = 942
- 2014.11.20简单赛车游戏
- UVA - 10911 Forming Quiz Teams 状态压缩
- 使用lucene,IKAnalyzer提取敏感词
- Android GridView(九宫格)
- Coursera台大机器学习课程笔记4 -- Training versus Testing
- 手动创建库后,sys用户查询dba_tablespaces报错:ORA-00942: table or view does not exist
- 《Java虚拟机原理图解》1.4 class文件中的字段表集合--field字段在class文件中是怎样组织的
- 的副书记和的疯狂了士大夫三大街
- Coursera台大机器学习课程笔记5 -- Theory of Generalization
- 关于服务器挂载共享文件
- Coursera台大机器学习课程笔记6 -- The VC Dimension
- LeetCode题解:Binary Tree Level Order Traversal
- Coursera台大机器学习课程笔记7 -- Noise and Error
- java 堆栈的区别