Re: moving datafile

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Fri, 20 Aug 1999 13:40:07 GMT
Message-ID: <37BD5AB7.88EAA745@edcmail.cr.usgs.gov>

Try this. The tablespace is the one that the datafile belongs to.

ALTER TABLESPACE tablespace_name OFFLINE; Use OS commands to move datafile.
ALTER TABLESPACE tablespace_name RENAME DATAFILE 'old_filename_&_location'

TO 'new_filename_&_location';
ALTER TABLESPACE tablespace_name ONLINE;

This can be done with the database up, but transactions to that tablespace will not be able to take place until the tablespace is brought back online.

HTH,
Brian

Karim AMRANI wrote:
>
> Hi,
>
> I'm really not an expert in Oracle DB but I was put in charge of it !
>
> We installed a 7.3.4 oracle db on solaris 2.6. We put user_data's
> data_file on the wrong partition on install.
> We need urgently to move the data_file to some other place (on the same
> machine).
> The database is in production.
>
> Does anyone know a simple manner to move the datafile (we can stop the
> database at night) ?
>
> Thanks,
>
> Karim AMRANI
> COGELOG
Received on Fri Aug 20 1999 - 08:40:07 CDT