Re: Help

From: zeb <thierry.constant1_at_free.fr>
Date: Sun, 23 Feb 2003 11:58:31 +0100
Message-ID: <3e58a8bb$0$260$626a54ce@news.free.fr>

"CSP" <cspp2201_at_netscape.net> a écrit dans le message de news: 3E571704.9020803_at_netscape.net...
> Hari,
>
> Do the following:
>
> 1. Alter tablespace <tablespace_name> OFFLINE; #-- I am assuming you
> database is in Archive log mode.

Is the archive log necessary ????

> 2. !mv /opt/oracle/data/<file_name> /opt/oracle/<file_name>
> 3. alter database rename file <from> to <new_location>;
> 4. alter tablespace <tablespace_name> ONLINE;
Received on Sun Feb 23 2003 - 04:58:31 CST