Seema,
It is not a risky process. The proper way to do it is:
Alter tablespace {name} offline;
! host copy filename to newlocation;
Alter database rename file 'oldname' to 'newname';
alter tablespace {name} online;
* backup your database! *
if all goes well, remove the old file.
You
Dear DBAs
Question about alter database rename file '/oldlocation/datafile1' to
'/newlocation/datafile1';
This command ususal to move a datafile to a new location.
In case of rename file, I mean here
'/oldlocation/datafile1' to '/newlocation/newdatafilename'; or
'/oldlocation/datafile1' to
Hi Mitchell,
The steps should work. Oracle recommends to shutdown the mounted database before opening again after the change(I am not sure about if this is required) I would just open the closed db.
I usually,
a.Backup the database(going to do a structural change!)
b.Take the tablespace connected
Mitchell wrote:
1. shutdown database (normal or immediate)
2. cp /oldlocation/datafile1 /newlocation/newdatafilename or
mv /oldlocation/datafile1 /oldlocation/newdatafilename
nope don't use mv. the database needs to see the old datafile until you
rename it. so use cp and then after
You do not need to shut the database. Only take the tablespace offline
where the datafiles are reorganized.
Rao
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, May 07, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Dear DBAs
Question about alter database rename file
Why not to make tablespace offline, rename datafile in oracle and them use
unix mv command to move it? Copy is not good ig there is no space.
Alex Hillman
-Original Message-
Sent: Monday, May 07, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L
Mitchell wrote:
1. shutdown
Title: RE: Rename Datafile
-Original Message-
From: Thater, William [mailto:[EMAIL PROTECTED]]
On Mon, 7 May 2001,Hillman, Alex scribbled on the wall in
glitter crayon:
-Why not to make tablespace offline, rename datafile in
oracle and them use
-unix mv command to move