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

    p_file_20: "z305 ... table or view does not exist"

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    When we run p_file_20, even though util a/17/11/2 for ABC50 shows that the z305 *does* exist, we get the error message:

    Oracle error: update_cursor z305
    ORA-00942: table or view does not exist

    Even when you have USER-SHARING=N (explicitly or by default, in the xxx50/tab//tab100) and, therefore, all the z305 records will be in the ADM library, with none in the $usr_library, the system wants the z305 table to be defined in the $usr_library.

    Using util a/17/1 to define the z305 in the $usr_library eliminated the error message.

    • Article last edited: 10/8/2013