Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    After upgrade, read-only user cannot find table in Oracle.

    • Product: Voyager
    • Product Version: All
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

     

    Problem Symptoms

    • After upgrade, read-only user cannot find table in Oracle.
    • Query or describe table results in error:

    ERROR:
    ORA-04043: object "XXXDB"."[table name]" does not exist

    Cause

    This problem may occur if the read-only Oracle user needs to be rebuilt.

    Resolution

    If you are experiencing these symptoms, try rebuilding the read-only Oracle user. 

    If you are a TotalCare customer or would prefer Support do this, please open a Case via the Support Portal.

    Additional Information

    Instructions for rebuilding read-only user: Create & refresh Oracle read-only users for ODBC 

     


    • Article last edited: 02-Mar-2016