Re: Question: Safest way to 'recreate' a tablespace

I believe the Oracle documentation gives an example of this:

1. alter tablespace <tablespace_name> offline normal;
2. Copy the datafile in question to the desired location with the relevant O/S command.
3. alter tablespace <tablespace_name> rename datafile '<old_datafile_name>' to '<new_datafile_name>';
4. alter tablespace <tablespace_name> online;

Clean up by deleting the unwanted datafile with the O/S. Received on Wed Oct 26 2005 - 14:55:01 CDT