Re: Moving Database Files

On 3 Apr 1995, Donald W. Pope II wrote:

>
> I need to move a database file from one disk to another.
> I think I know what I need to do, but I'm hoping someone can
> verify these steps:
>
> sqldba> shutdown
>
> Go to OS, and rename file to new disk
>
> sqldba> startup mount aptsprod
>
> sqldba> alter database rename file 'usr1:[x.db]prod1.dbs' to
> 'usr2:[x.db]prod2.dbs'
>
> sqldba> alter database open
>
>
> I am using Oracle RDBMS 6.0.31.
>
> Thanks,
> Don
>
>

	Depending on -which- files you need to move, you may
	not have to shutdown.  If it isn't the SYSTEM tablespace,
	or a tablespace with active rollback segments, you may
	be able to:

		alter tablespace xxxx offline;
		(move the files to new location)
		alter tablespace xxxx rename datafile
			'oldpath' to 'newpath';
		alter tablespace xxxx online;

	helena

--
<:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>
<: Helena Whitaker, Database Administrator      helena_at_creighton.edu :>
<: Creighton University               (0800-1630 CT)   (402)280-2311 :>
<: Old Gym - 2500 California Plaza                fax  (402)280-2573 :>
<: Admin Computing-Fin Sys Spt          Platform: HP-UX 9.0.4 (unix) :>
<: Omaha, NE 68178-0046              HP 9000/887 (aka H50), 842, 806 :>
<:                            Oracle 6.0.36.7.1/Banner Finance 2.0.3 :>
<:                            Oracle 7.1.3/DeLair Patient Accounting :>
<:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>