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