RE: unhacking file$

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 21 Feb 2006 14:40:58 -0500
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410506780834@usahm236.amer.corp.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 21 2006 - 13:40:58 CST