Re:RENAME DATAFILE

From: <dgoulet_at_vicr.com>
Date: Wed, 23 Jan 2002 13:01:45 -0800
Message-ID: <F001.003F92E8.20020123125941@fatcity.com>

Renaming or moving a datafile is a two step proposition. Whether or not you do it with the database running depends on the archive log mode of the database. If at all possible the OS portion should be done with the database shutdown. If your in noarchive log mode then you have no choice. If your in archive log mode then you can take the tablespace and datafile offline, move/rename the file, alter database rename file <old> to <new>, recover the tablespace, and bring it back online.

If at all possible, take a cold backup BEFORE and AFTER. In all cases use the 'alter database backup controlfile to trace' command, just in case you end up rebuilding your control file(s).

Dick Goulet

____________________Reply Separator____________________
Author: "Seema Singh" <oracledbam_at_hotmail.com>
Date:       1/23/2002 12:43 PM

Hi
Rename data file from one location to another location is riskly process? If some thing wrong what will happened?Can I do it database on condition? Can I do it when db is running?If yes then it is risky?

Thx
-Seema

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Seema Singh
INET: oracledbam_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message