In Oracle 9i I Drop DATA DICTIONARY VIEW DBA_DATA_FILES by using normal SQL command DROP .
SQL> DROP VIEW DBA_DATA_FILES;
SQL> DROP VIEW DBA_FREE_SPACE_COALESCED;
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..........
Click Here to Expand Forum to Full Width