SQL> DROP VIEW DBA_FREE_SPACE_COALESCED;

[smdakram]

!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..........

[pando]

duplicate thread closing