Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datafile rename

607104Jul 2 2008 — edited Jul 2 2008
database is 10.1.0.5 on windows 2003.

I need to rename a datafile, the procedure I follow is:

1). ALTER TABLESPACE DATA OFFLINE NORMAL;

2). --Rename the datafiles using the operating system

Here I am bit confused. I am on windows does this mean, the same procedure need to follow as we rename any normal file on windows or is there any other procedure to accomplish this?

3). ALTER TABLESPACE DATA RENAME DATAFILE 'Z:\ORA\ORCL\DATA1.DBF' TO 'Z:\ORA\ORCL\DATA2.DBF';

4). ALTER TABLESPACE DATA ONLINE;

Does the above statement need any recovery or will it be online normally. Database would be open when doing this. Can anyone please confirm is this right procedure to rename a datafile when database is open.


Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2008
Added on Jul 2 2008
#general-database-discussions
5 comments
692 views