创建测试表空间:
SQL> create tablespace test datafile '+data';
Tablespace created.
SQL> alter tablespace test add datafile '+data' size 10m;
Tablespace altered.
查看文件:
ASMCMD> ls
SYSAUX.257.893081249
SYSTEM.256.893081249
TEST.270.894383731
TEST.271.894383797
UNDOTBS1.258.893081251
UNDOTBS2.265.893081787
USERS.259.893081251
删掉表空间:
SQL> drop tablespace test;
Tablespace dropped.
查看文件:
ASMCMD> ls
SYSAUX.257.893081249
SYSTEM.256.893081249
UNDOTBS1.258.893081251
UNDOTBS2.265.893081787
USERS.259.893081251
哇,这竟然是