September 2, 2005
Oracle10gR2:New Features-drop empty datafile
作者:eygle
出处:http://blog.eygle.com
在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. |
Posted by eygle at 9:28 AM | Comments (3)
Oracle 10g Release 2 all available
作者:eygle
出处:http://blog.eygle.com
从8月26日开始，Oracle10gR2在各大平台上的版本都已经发布了，等待了很久的朋友们可以到OTN上下载试用了:
http://www.oracle.com/technology/software/products/database/oracle10g/index.html
Posted by eygle at 9:03 AM | Comments (4)