ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle error.

oracle error.

原创 Linux操作系统 作者:ljs4053 时间:2011-09-07 15:49:03 0 删除 编辑
1.SQL> startup open;
ORACLE instance started.

Total System Global Area 1029484544 bytes
Fixed Size                  1379100 bytes
Variable Size             373294308 bytes
Database Buffers          650117120 bytes
Redo Buffers                4694016 bytes
Database mounted.
Database opened.
SQL> conn test/test;
Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
Connected.
在system下运行pupbld.sql
SQL> conn system/Ljs03201;
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
Connected.
SQL> @D:\app\ffybjf\product\11.2.0\dbhome_1\sqlplus\admin\pupbld.sql

Synonym dropped.

CREATE TABLE SQLPLUS_PRODUCT_PROFILE AS
             *
ERROR at line 1:
ORA-25153: Temporary Tablespace is Empty
ORA-00955: name is already used by an existing object


DROP TABLE PRODUCT_USER_PROFILE
           *
3.临时表空间为空,怀疑表空间不存在,或者数据文件不见了。查看数据文件发现存在,查找表空间名,select * from v$tablespace; 表空间不存在,怀疑之前手工创建controlfile时,忘了加些表空间,加入。


4. ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\APP\FFYBJF\ORADATA\ORCL\TEMP01.DBF'
     SIZE 100663296  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
5.结果正常.
  

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

下一篇: SP2-0575错误
请登录后发表评论 登录
全部评论

注册时间:2010-02-22

  • 博文量
    14
  • 访问量
    10491