>>> 오라클 필요없는 테이블 스페이스 오프라인후 삭제하기
alter database datafile 'data/data.dfb' offline drop;
alter database open ;
drop tablespace TEST_SPACE includeing contents ;
> 해당테이블스페이스의 데이터파일들 조회하기
select file_id,file_name,tablespace_name from dba_data_files
order by tablespace_name ,file_id
> 테이블스페이스의 데이터파일 하나씩 삭제하기
alter tablespace TEST_SPACE drop datafile 'aaa.dbf' ;
drop tablespace DB_INDEXSPACE includeing contents ;
drop tablespace DB_INDEXSPACE includeing contents ;
select file_id,file_name,tablespace_name from dba_data_files order by tablespace_name ,file_id ;
drop tablespace DB_INDEXSPACE including contents and datafiles ;
select username, default_tablespace, temporary_tablespace from dba_users ;
select tablespace_name,segment_name from dba_segments where tablespace_name ='DB_INDEXSPACE'
|
|
|
