Oracle 10g/10g - 실습
Tablespace 실습 #6
I유령I
2010. 2. 27. 21:02
테이블스페이스의 삭제
SQL> drop tablespace insa
2 including contents and datafiles cascade constraints;
Tablespace dropped.
SQL> select tablespace_name, bytes, file_name from dba_data_files;
TABLESPACE_NAME BYTES FILE_NAME
---------------- ---------- --------------------------------------------------
USERS 5242880 /home/oracle/oradata/testdb/users01.dbf
SYSAUX 251658240 /home/oracle/oradata/testdb/sysaux01.dbf
UNDOTBS1 36700160 /home/oracle/oradata/testdb/undotbs01.dbf
SYSTEM 503316480 /home/oracle/oradata/system01.dbf
EXAMPLE 104857600 /home/oracle/oradata/testdb/example01.dbf
SQL>