Is there anyway we can move datafiles from 1 TS to another TS. If so, how can this be done? Thanks
Printable View
Is there anyway we can move datafiles from 1 TS to another TS. If so, how can this be done? Thanks
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;