!hello
In Oracle 9i I Drop DATA DICTIONARY VIEW DBA_DATA_FILES by using normal SQL command DROP .
SQL> DROP VIEW DBA_DATA_FILES;
view drop.
SQL> DROP VIEW DBA_FREE_SPACE_COALESCED;
view drop.
After that when i try to select the view but i got these error::
SQL> select * from dba_data_files
*
ERROR at line 1:
ORA-00980: synonym translation is no longer valid
===============
I SHUTDOWN the Database and again i run CATALOG.SQL (script)
but still iam getting these ERROR
How can i get back these Two views
Can u Help me..........
