SQL> DROP VIEW DBA_FREE_SPACE_COALESCED;
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL> DROP VIEW DBA_FREE_SPACE_COALESCED;

  1. #1
    Join Date
    Aug 2001
    Location
    cuddapah
    Posts
    145
    !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..........


    Share on Google+

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    duplicate thread closing
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width