unhacking file$

  • From: john d parker <orclwzrd@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Feb 2006 11:21:46 -0800 (PST)

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


Other related posts: