p_file_20: "z305 ... table or view does not exist"
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
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
Resolution:
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