Re: Quick move tablespace
From: Eugene Pokopac <epokopac_at_gmail.com>
Date: Thu, 7 Jan 2010 06:29:02 -0800 (PST)
Message-ID: <edc0b853-8bd1-423a-acac-8e4a3fb46016_at_22g2000yqr.googlegroups.com>
1 - ALTER TABLESPACE <ts_name> OFFLINE ;
Date: Thu, 7 Jan 2010 06:29:02 -0800 (PST)
Message-ID: <edc0b853-8bd1-423a-acac-8e4a3fb46016_at_22g2000yqr.googlegroups.com>
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 ; Received on Thu Jan 07 2010 - 08:29:02 CST