又测试了一下:
SQL> create tablespace lxptest;
Tablespace created
ASMCMD> ls -l
Type Redund Striped Time Sys Name
DATAFILE UNPROT COARSE DEC 10 09:00:00 Y IDSLOG.276.723225311
DATAFILE UNPROT COARSE DEC 10 06:00:00 Y IDSLOG2.305.731845233
DATAFILE UNPROT COARSE DEC 10 06:00:00 Y IDSLOG2.310.737055513
DATAFILE UNPROT COARSE DEC 10 10:00:00 Y LXPTEST.315.737374275
DATAFILE UNPROT COARSE DEC 10 04:00:00 Y SYSAUX.266.723222505
DATAFILE UNPROT COARSE DEC 10 04:00:00 Y SYSTEM.264.723222443
DATAFILE UNPROT COARSE DEC 10 05:00:00 Y TRSIDS.275.725066545
DATAFILE UNPROT COARSE DEC 10 04:00:00 Y UNDOTBS1.265.723222457
DATAFILE UNPROT COARSE DEC 10 04:00:00 Y UNDOTBS2.268.723222517
DATAFILE UNPROT COARSE DEC 10 04:00:00 Y USERS.269.723222565
N idslog.dbf => +DATA/SMSDB/DATAFILE/IDSLOG.276.723225311
N idslog2.dbf => +DATA/SMSDB/DATAFILE/IDSLOG2.305.731845233
N idslog3.dbf => +DATA/SMSDB/DATAFILE/IDSLOG2.310.737055513
N trsids.dbf => +DATA/SMSDB/DATAFILE/TRSIDS.275.725066545
SQL> drop tablespace lxptest;
Tablespace dropped
ASMCMD> ls -l
Type Redund Striped Time Sys Name
DATAFILE UNPROT COARSE DEC 10 09:00:00 Y IDSLOG.276.723225311
DATAFILE UNPROT COARSE DEC 10 06:00:00 Y IDSLOG2.305.731845233
DATAFILE UNPROT COARSE DEC 10 06:00:00 Y IDSLOG2.310.737055513
DATAFILE UNPROT COARSE DEC 10 04:00:00 Y SYSAUX.266.723222505
DATAFILE UNPROT COARSE DEC 10 04:00:00 Y SYSTEM.264.723222443
DATAFILE UNPROT COARSE DEC 10 05:00:00 Y TRSIDS.275.725066545
DATAFILE UNPROT COARSE DEC 10 04:00:00 Y UNDOTBS1.265.723222457
DATAFILE UNPROT COARSE DEC 10 04:00:00 Y UNDOTBS2.268.723222517
DATAFILE UNPROT COARSE DEC 10 04:00:00 Y USERS.269.723222565
N idslog.dbf => +DATA/SMSDB/DATAFILE/IDSLOG.276.723225311
N idslog2.dbf => +DATA/SMSDB/DATAFILE/IDSLOG2.305.731845233
N idslog3.dbf => +DATA/SMSDB/DATAFILE/IDSLOG2.310.737055513
N trsids.dbf => +DATA/SMSDB/DATAFILE/TRSIDS.275.725066545
OMF没问题。
知道了,那个表空间是我手工指定的数据文件,所以删除表空间时不能自动删掉。
感觉oracle应该把手工指定的数据文件也能附带删掉,就更智能了。
[本帖最后由 lixunpeng 于 2010-12-10 10:22 编辑]