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/...";
- References:
- RE: Resizing a file with two //
- From: Steele, Theresa
Other related posts:
- » Resizing a file with two //
- » Re: Resizing a file with two //
- » Re: Resizing a file with two //
- » Re: Resizing a file with two //
- » Re: Resizing a file with two //
- » RE: Resizing a file with two //
- » RE: Resizing a file with two //
- » Re: Resizing a file with two //
- » Re: Resizing a file with two //
- » Re: Resizing a file with two //
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/...";
- RE: Resizing a file with two //
- From: Steele, Theresa