Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Philippines
    Posts
    10

    Exclamation Unanswered: Cannot select from data dictionary

    Hi
    Urgent Help!! Suddenly, we cannot select from data dictionary. Even describe its tables/views.

    SQL> desc dba_tables
    Object does not exist.


    Error we encountered was ORA-0980 synonym translation is no longer valid.

    Thanks a lot!

  2. #2
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    Hi,

    You did not mention as what user you are connected.
    did you change anything regarding any users created at database creation time ? If so, rerun scripts like catproc etc, after you have made an export or backup.
    Verify if any objects belonging to the sys and system user are invalid, if possible. If not, i think your datadictionary is screwed up.

    good luck
    Edwin van Hattem
    OCP DBA / System analyst

  3. #3
    Join Date
    Sep 2003
    Location
    Philippines
    Posts
    10
    I'm loggin as system user..We have rerun script catproc after we found out this problem & recompile invalid objects & bounce DB..Unfortunately, problem persist & upon looking more deeply, found out there were MISSING ROLES!!! We dont know why it suddenly lacks in the DB...It is still now under investigation but those roles were recreated.

    Anyway, thanks for the advise!

Posting Permissions

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