Oracle表空间-删除

查看 表空间
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>