RE: unhacking file$
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 21 Feb 2006 14:40:58 -0500
I guess zero change that a commit has not been issued and the offending
session is still open?
Since whatever you are about to do is unsupported I suggest you start by
making an immediate hot backup. If the database is small enough a full
export would not hurt either.
You did not mention production or test, etc.... You might consider
restore and point in time recovery.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of john d parker
Sent: Tuesday, February 21, 2006 2:22 PM
To: oracle-l
Subject: unhacking file$
I need to "unhack" file$. A well meaning DBA deleted a row from file$
while trying to remove an unneeded datafile from a tablespace.
Currently, I can see the file thru v$datafile and it's status is online.
I cannot see the file thru dba_data_files which feeds from file$.
Any suggestions on putting the entry back in file$? If it helps any,
this is 9.2.0.6 on AIX.
John Parker
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
