Drop tablespace and reuse datafile to new tablespace
Hi,
I plan to drop one of the empty tablespace and assign to new tablespace let call 'TBS_NEW'.
May i know how should i proceed.
Oracle 9i ( 9.2.0.6 ) version
SQL> select FILE_NAME,TABLESPACE_NAME from dba_data_files
2 where TABLESPACE_NAME='YMS_TBS';
FILE_NAME TABLESPACE_NAME
-------------------------------------------------- ---------------
/u00/oradata/ODSDWPD/yms_tbs_001.dbf YMS_TBS
/u00/oradata/ODSDWPD/yms_tbs_002.dbf YMS_TBS
/u00/oradata/ODSDWPD/yms_tbs_003.dbf YMS_TBS
/u00/oradata/ODSDWPD/yms_tbs_004.dbf YMS_TBS
/u00/oradata/ODSDWPD/yms_tbs_005.dbf YMS_TBS
SQL>
SQL> select OWNER,SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME from dba_segments where TABLESPACE_NAME='YMS_TBS';