Re: moving a datafile

From: <mgogala_at_rocketmail.com>
Date: Fri, 04 Dec 1998 01:41:29 GMT
Message-ID: <747eka$1pc$1@nnrp1.dejanews.com>

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.
>
>

Here is the procedure:
Sqlplus system/manager
alter tablespace dataspace offline;

Then verify that the tablespace is really offline, then copy the file to the new file system (not

alter database rename file '/tmp/mmmm' to '/tmp/nnnn';

or whatever your file names are. Then bring the tablespace online;

--
Mladen Gogala

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