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

Description:
I ran p-manage-07 as a test, and see these Oracle errors in the log:

>> DROP TABLE ABC01.Z13U
*
ERROR at line 1:
ORA-00942: table or view does not exist
...
...

>> TABLESPACE TS2X
*
ERROR at line 5:
ORA-00959: tablespace 'TS2X' does not exist

The job appears to have run correctly, but I'm curious what is causing the errors?

Resolution:
The error messages occurred because of the references to the z13u and ts2X the $aleph_root/tab/file_list.BIB file_list template. (The template is used when the abc01 prof_library has the line: file_list_type=BIB.
If a table is not in the $data_root/file_list but is in file_list.BIB, the program uses the latter.)

If you want to have a z13u table, you have two choices:
1. Add z13u to your abc01 file list
2. Add the following line to the abc01 prof_library:
setenv file_list_ts2 xxxxx <where xxxxx is the tablespace you want used when the file_list template has "TS2D">

This is described in detail in KB's 8192-3719 and 8037.

If you *don't* want to have a z13u table, then you can, as described in KB 8192-5095, insert
NA z13u
NA z13u_id
lines in your abc01 file_list.

• Article last edited: 10/8/2013