« Oracle 10g Release 2 all available | Blog首页 | How to Use Oracle10g release 2 ASM »
Oracle10gR2:New Features-drop empty datafile
作者：eygle |【转载时请务必以超链接形式标明文章原始出处和作者信息及本声明】链接：http://www.eygle.com/archives/2005/09/oracle_database_1.html
在Oracle10gR2中，Oracle允许我们直接从表空间中drop掉空的数据文件，这个删除的文件再也不会讨厌的显示在dba_data_files视图中了。
SQL> create tablespace test; Tablespace created. SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- +ORADG/danaly/datafile/system.264.600016955 +ORADG/danaly/datafile/undotbs1.265.600016969 +ORADG/danaly/datafile/sysaux.266.600016977 +ORADG/danaly/datafile/users.268.600016987 +ORADG/danaly/datafile/test.271.600082589 SQL> alter tablespace test add datafile; Tablespace altered. SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- +ORADG/danaly/datafile/system.264.600016955 +ORADG/danaly/datafile/undotbs1.265.600016969 +ORADG/danaly/datafile/sysaux.266.600016977 +ORADG/danaly/datafile/users.268.600016987 +ORADG/danaly/datafile/test.271.600082589 +ORADG/danaly/datafile/test.272.600082607 6 rows selected. SQL> select file_name from dba_data_files; FILE_NAME -------------------------------------------------------------------------------- +ORADG/danaly/datafile/system.264.600016955 +ORADG/danaly/datafile/undotbs1.265.600016969 +ORADG/danaly/datafile/sysaux.266.600016977 +ORADG/danaly/datafile/users.268.600016987 +ORADG/danaly/datafile/test.271.600082589 +ORADG/danaly/datafile/test.272.600082607 6 rows selected. SQL> alter tablespace test drop datafile '+ORADG/danaly/datafile/test.272.600082607' ; Tablespace altered. SQL> select file_name from dba_data_files; FILE_NAME -------------------------------------------------------------------------------- +ORADG/danaly/datafile/system.264.600016955 +ORADG/danaly/datafile/undotbs1.265.600016969 +ORADG/danaly/datafile/sysaux.266.600016977 +ORADG/danaly/datafile/users.268.600016987 +ORADG/danaly/datafile/test.271.600082589 SQL> |
虽然还有一定的限制，但是这仍然是前进了一步。
SQL> drop tablespace test; Tablespace dropped. |
-----
这篇 【Oracle10gR2:New Features-drop empty datafile】来自 www.eygle.com | CSDN技术网摘| del.icio.us|365Key
By eygle on 2005-09-02 09:28 | Comments (3) | Posted to Oracle10g/11g | Edit |Pageviews:
网上相关主题:
留言 (3)
其实……这个准确点说是 链接 一下，不是编译
oracle 安装文件基本都是已经编译好的 object ,只是根据不同选项 link 一下 :)
所以在有些平台，比如 AIX 下 没有编译器 ，也可以安装oracle
Posted by: biti_rainy at September 4, 2005 12:29 AM
界面太不友好了，回复错了，ft
Posted by: biti_rainy at September 4, 2005 12:34 AM
这个界面还算不错了：）
Posted by: eygle at September 4, 2005 6:42 PM
