查看 表空间
sql> select * from dba_data_files where tablespace_name like '%LIANXI%';
FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_STATUS
-------------------------------------------------------------------------------- ---------- ------------------------------ ---------- ---------- --------- ------------ -------------- ---------- ---------- ------------ ---------- ----------- -------------
C:\ORCL1122\DISK5\LIANXI01.DBF 6 LIANXI 52428800 6400 AVAILABLE 6 NO 0 0 0 52355072 6391 ONLINE
C:\ORCL1122\DISK5\LIANXI02.DBF 7 LIANXI 52428800 6400 AVAILABLE 7 NO 0 0 0 52355072 6391 ONLINE
C:\ORCL1122\DISK5\LIANXI_UNDO.DBF 8 LIANXI_UNDO 20971520 2560 AVAILABLE 8 NO 0 0 0 19922944 2432 ONLINE
C:\ORCL1122\DISK5\LIANXI_INDEX.DBF 9 LIANXI_INDEX 26214400 3200 AVAILABLE 9 YES 3435972198 4194302 256 25165824 3072 ONLINE
C:\ORCL1122\DISK5\LIANXI_INDEX02.DBF 10 LIANXI_INDEX 15728640 1920 AVAILABLE 10 NO 0 0 0 14680064 1792 ONLINE
删除表空间 lianxi_undo
sql>
drop tablespace lianxi_undo including contents and datafiles;
Tablespace dropped
查看 表空间 少了lianxi_undo sql> select * from dba_data_files where tablespace_name like '%LIANXI%'; FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_STATUS -------------------------------------------------------------------------------- ---------- ------------------------------ ---------- ---------- --------- ------------ -------------- ---------- ---------- ------------ ---------- ----------- ------------- C:\ORCL1122\DISK5\LIANXI01.DBF 6 LIANXI 52428800 6400 AVAILABLE 6 NO 0 0 0 52355072 6391 ONLINE C:\ORCL1122\DISK5\LIANXI02.DBF 7 LIANXI 52428800 6400 AVAILABLE 7 NO 0 0 0 52355072 6391 ONLINE C:\ORCL1122\DISK5\LIANXI_INDEX.DBF 9 LIANXI_INDEX 26214400 3200 AVAILABLE 9 YES 3435972198 4194302 256 25165824 3072 ONLINE C:\ORCL1122\DISK5\LIANXI_INDEX02.DBF 10 LIANXI_INDEX 15728640 1920 AVAILABLE 10 NO 0 0 0 14680064 1792 ONLINE sql>
