Re: Moving System Tablespace

leslie_at_darth.lfso.loral.com (Leslie Carter) writes: >
> I am trying to reorganize a database and am moving some tablespaces
 to
> different disks.

I am always moving/copying dbf files from not only directory to directory but also from system to system. What I do is shut the db down, move the file, delete the control files and then recreate them using a script. I created the script from the cr{SID}.sql script that recreates the control files. Like I said this allows me to move the dbfs from system to system of the same OS, eg. Sun to Sun, HP to HP.

BUT, this is not supported by Oracle Corp and any comments made by me are only my own knowledge and experience and is not in any way an endorsement by my employer or other companies mentioned.

Ronald Leedy	 			Oracle Corporation             
Application Demonstration Services	300 Oracle Parkway            
mailto:rleedy_at_us.oracle.com		M/S 3op15           
(415) 506-5179		        	Redwood Shores, CA  94065      
(415) 506-7814 (fax)     
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~