oracle 9i renaming datafiles.. replies

From: michael desouza <mike_at_archoak.fsworld.co.uk>
Date: Wed, 19 Jun 2002 22:59:03 +0100
Message-ID: <aequrl$1v1$1@newsg4.svr.pol.co.uk>

Guys

thsk for the replies , I did exactly what you suggested and it worked .

according to oracle , metalink document number 1027416.6, its does mention that its is possible to rename a datafile when the database is up , ie for example a 24*7 system

its does say to contact oracle support if it a 24*7 system , so i guess it must be possible, it does not say anything of taking the tablespace offline

anyway thks for your help guys , atleast it sorted my problem for the time being

. RENAMING A DATAFILE

I.A WITH THE DATABASE IN ARCHIVELOG MODE

If the database is up, offline the datafile.

ALTER DATABASE DATAFILE '<full_path_file_name>' OFFLINE;

2. Copy the datafile to the new name/location at operating system level.

3. If the database is down, mount it.

STARTUP MOUNT This command will read the control file but will not mount the datafiles.

4. Rename the file inside Oracle.

ALTER DATABASE RENAME FILE '<old_full_path_file_name>' TO '<new_full_path_file_name>';

5. If the database is at mount point, open it. If the datafile is

offline, bring it back online.

ALTER DATABASE DATAFILE '<new_full_path_file_name>' ONLINE; Received on Wed Jun 19 2002 - 16:59:03 CDT