unhacking file$

From: john d parker <orclwzrd_at_yahoo.com>
Date: Tue, 21 Feb 2006 11:21:46 -0800 (PST)
Message-ID: <20060221192146.44722.qmail@web32613.mail.mud.yahoo.com>

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

Received on Tue Feb 21 2006 - 13:21:46 CST