Control Tables

Hi List,

Where can I get a list of all tables in the control tables data source?

Thanks

Hi Samarchon,
You can find one on KG. Though I don't have the doc with me (I am at home), but I am also using that doc for my reference. It list out all the tables in all the schemas (DD,SVM,SYS,PD733x..etc) except for Business data tables.
In case you are unable to find, do let me know I can mail it to you.
Good Luck

Hi, Sunny,
Would please post the KG Doc ID (ott-##-###).
I'm unable to find the Doc you introduced which sounds great.
Thanks,
Eugene

If you look in the Install Reference Guide - Sept 2000 - start on packe 106.

Hi Sunny,

I have seen that doc once in KG. I am unable to find it again. Can you please email it to me or post the doc #?

Thanks

Check out OTI-01-0069.....Joy

If you are using Oracle then use the following sql statement
"Select table_name from dba_tables where owner = ' Control Table owners".

You can also go into Object Configuration Manager (OCM), Select Control Tables for one environment in the QBE line, and press Find. This will show you all tables which you have mapped in OCM to the Control Tables data source.

Of course, Vivek's SQL command will also work just fine!