Move Datafiles

[st2000]

Is there anyway we can move datafiles from 1 TS to another TS. If so, how can this be done? Thanks

[marist89]

Depends on what you want to do. If you want to move the datafiles containing the data, then no, it can't be done. If you just want to reuse a datafile from an old tablespace, then yes. Say datafile /u01/oradata/xyz/xyz01.dbf is part of the xyz tablespace.

alter tablespace xyz offline;
drop tablespace xyz;
create tablespace abc datafile '/u01/oradata/xyz/xyz01.dbf' reuse;