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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- High Executions Of Statement "delete from smon_scn_time..."delete
- Migrate from SQL SERVER to Oracle 10GSQLServerOracle 10g
- Initialization Parameter Changes from 9i to 10g
- mysql 的delete from where 子查詢的一些限制MySqldelete
- Oracle 10g upgrade from 10.2.0.1 to 10.2.0.4Oracle 10g
- Upgrading from Oracle Database 10g to 11gOracleDatabase
- 【11g】【10g】【實驗】spfile檔案的恢復(from memory;)
- delete input 與 delete all inputdelete
- delete OBSOLETE 與 delete expirieddelete
- deletedelete
- Object Difference In TTS Migration From 10g To 11g (文件 ID 1643239.1)ObjectTTS
- 10G rac crsd.log :th_select_handler: Failed to retrieve procctx from htAI
- delete 和 delete [] 的真正區別delete
- delete與delete[]需要注意的地方delete
- FormData delete()ORMdelete
- URLSearchParams delete()delete
- JavaScript deleteJavaScriptdelete
- DELETE STATISTICSdelete
- rman 中delete 與delete force 的區別delete
- Removing 10g Database,Software from AIX, HP-UX, Linux, Sun and Tru64_275493.1REMDatabaseAILinux
- MySQL Delete PHPMySqldeletePHP
- WeakMap delete() 方法delete
- WeakSet delete() 方法delete
- Map delete() 方法delete
- SQL__DELETESQLdelete
- Set delete() 方法delete
- URLSearchParams delete() 方法delete
- JavaScript delete用法JavaScriptdelete
- Delete the temp tabledelete
- RMAN 中delete exipired 和 delete obsolete 的區別delete
- backup archivelog delete input 與delete all input 區別Hivedelete
- rman 中的 delete all input 和 delete input 的區別delete
- Handler_delete和Com_delete有什麼關係delete
- 740. Delete and Earndelete
- postgresql delete duplicated rowsSQLdelete
- Diffrence Between delete and truncatedelete
- truncate 比 delete 慢delete
- drop、delete 與truncatedelete