Re: Resizing a file with two //

  • From: "David Sharples" <davidsharples@xxxxxxxxx>
  • To: Theresa.Steele@xxxxxxxxxx
  • Date: Fri, 28 Jul 2006 00:28:45 +0100

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

On 28/07/06, Steele, Theresa <Theresa.Steele@xxxxxxxxxx> 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/...";

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2006