Messy Oracle table for MGU13

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

Description:
I was emptying out ABC13 in preparation for loading a new batch of authorites, and ran util a/17/11/1 (Space Utilization in ABC13 - All Oracle tables).

First it says: make_library_file_list: env file_list_size does not exists. Using data_root/file_list as is

But the tables list after that are quite different from the file list in ABC13.

The test server seems okay.

The prof library settings are the same:
setenv active_library ABC13
setenv library_type AUT
setenv library_size DEMO

As are the file lists.

So production's ABC13 table set must have been created before the prof_library was adjusted?

I know how to delete tables via SQL. Should I do that with all of these ABC13 tables using TS0 rather than our TSnD and TSnX spaces?

Resolution:
From Jerry:

I don't think the Service Pack will make a difference.

Please try deleting the tables with SQL before running the util:

s+ abc13

SQL-ABC13> delete table z00r;
SQL-ABC13> delete table z0101;
etc.

(Make sure you are in abc13 when doing these things.)

Then do util a/17/1 all.

[From site:]
I have removed the unwanted tables from ABC13 on production. Production and test are now in sync.

• Article last edited: 10/8/2013