How to know what library a particular Oracle table is found in *MASTER RECORD*

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

Description:
We see a reference to the "Z05" table, but I have no idea what library it's in.

Is there some easy way to determine what library (or libraries) a particular table is in?

Resolution:
Two methods:

1. s+ usm01 <or any library>

SQL> select OWNER from all_tables where table_name = 'Z05';

2. cd $aleph_root/tab

grep -i z05 *

If you see "file_list.BIB" in the first column, that means it's in the bib library.
If you see "file_list.VIR", that means it's in VIR01.
Etc.

For those of you who do not have access to these tools, I am attaching a Word document with the output from the following SQL in version 18:

SQL> select table_name, owner from all_tables where owner in ('USM01','USM10','USM30','USM40','USM50','USM60','USM90','ILLSV','VIR01','USR00') order by table_name, owner;

• Article last edited: 10/8/2013