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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to