Re: Resizing a file with two //

no need for steps 1 and 2 - just take the tablespace offline

On 28/07/06, Steele, Theresa <Theresa.Steele_at_mdsinc.com> wrote:
>
> Before you do the rename command, do :
> 1-shutdown immediate
> 2-startup mount
> 3-move the file at the OS level to what you want the new name to be <<db
> must be in mount mode>>
> 4-then issue "alter database rename file "/u03//..." to "/u03/...";
>

--
http://www.freelists.org/webpage/oracle-l