Re: Quick move tablespace

From: Mladen Gogala <no_at_email.here.invalid>
Date: Thu, 7 Jan 2010 20:06:03 +0000 (UTC)
Message-ID: <pan.2010.01.07.20.06.02_at_email.here.invalid>

On Thu, 07 Jan 2010 06:29:02 -0800, Eugene Pokopac wrote:

> 1 - ALTER TABLESPACE <ts_name> OFFLINE ;
>
> 2 - At the server - Issue appropriate commands to copy ALL files in the
> tablespace from the OLD location to the NEW location:
>
> Unix example: mv /u015/ORACLE/ofdvdata/<filename> /u004/ORACLE/
> ofdv/<filename>
>
> 3 - ALTER TABLESPACE <ts_name> RENAME DATAFILE
> /u015/ORACLE/ofdvdata/<filename> TO
> /u004/ORACLE/ofdv/<filename> ;
>
> 4 - ALTER TABLESPACE <ts_name> ONLINE ;

Eugene, how about doing a little testing?

-- 
http://mgogala.byethost5.com

Received on Thu Jan 07 2010 - 14:06:03 CST