DELETE from DBA_TABLESPACES IN 10G

delete from dba_tablespaces where tablespace_name

[@more@]

DELETE from DBA_TABLESPACES IN 10G

SQL> delete from dba_tablespaces where tablespace_name='DTS';

1 row deleted.

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS
EXAMPLE
INFOCENTER
BBSC
MQ
PERFSTAT

10 rows selected.

SQL>
SQL> drop tablespace dts;
drop tablespace dts
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [4348], [U], [0], [11], [], [], [],
[]

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 536870912 bytes
Fixed Size 2074080 bytes
Variable Size 356518432 bytes
Database Buffers 171966464 bytes
Redo Buffers 6311936 bytes
Database mounted.
Database opened.

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS
EXAMPLE
INFOCENTER
BBSC
MQ
PERFSTAT

10 rows selected.

SQL> conn / as sysdba
Connected.
SQL> create tablespace dts datafile '/disk/db/oracle/datafile/ora10g/dts' size 10m;
create tablespace dts datafile '/disk/db/oracle/datafile/ora10g/dts' size 10m
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [25015], [11], [11], [10], [], [],
[], []

SQL> shutdown immediate
ORA-01116: error in opening database file 10
ORA-01110: data file 10: '/disk/db/oracle/datafile/ora10g/dts.bdf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

SQL> alter database datafile '/disk/db/oracle/datafile/ora10g/dts.bdf' offline;

Database altered.

一切正常，怀疑是oracle 的bug。

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

转载于:http://blog.itpub.net/34596/viewspace-1000870/