Re: moving a datafile

From: <satar_at_my-dejanews.com>
Date: Fri, 04 Dec 1998 00:22:16 GMT
Message-ID: <7479vl$tmd$1@nnrp1.dejanews.com>

Shutdown the database normal or immediate. gnat% dbshut 2. startup mount SVRMGR> startup mount; ORACLE instance started. Total System Global Area 4508464 bytes Fixed Size 39816 bytes Variable Size 4050856 bytes Database Buffers 409600 bytes Redo Buffers 8192 bytes Database mounted. SVRMGR> 3. Use 'cp' or your OS copy command: gnat% cp system01.dbf /oracle/backup 4. Use the Alter database command: SVRMGR> alter database rename file '/oracle/oradata/ora7/system01.dbf' to '/orac le/backup/system01.dbf'; 5. Open the database. SVRMGR> alter database open;

Good Luck...
Satar

In article <3667011F.58F22FE7_at_bigfoot.com>, Doug Cowles <dcowles_at_bigfoot.com> wrote:
> Can anyone outline a procedure for moving a datafile
> to a different filesystem without creating any problems?
> I'm running out of room fast on a disk, and don't want to
> interrupt anything.
>
> Thanks,
> Dc.
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 03 1998 - 18:22:16 CST