Does anyone know how to view the structure of an oracle 8.0.4 table which is available on a given instance via dblink to another instance?
I suspect we can’t see the structure (i.e. columns) in Designer because BO is reading an oracle system table on the current machine, and because the desired table is ‘dblinked’ to this machine, info about that table does not appear in the oracle system table.
Does anyone have experience or info regarding this, including maybe the name of the oracle system table that BO reads for columns?
In a message dated 98-09-01 11:59:18 EDT, you write:
Does anyone have experience or info regarding this, including maybe
the name of the oracle system table that BO reads for columns?
Thanks,
Jason Beard
AGD Consulting
Look in the Oracle directory of your BusinessObjects directory. There you will find a number of files, one of which is stora7xx.txt. The “xx” will be replaced by a two letter code denoting the language. For me it is “en” for English.
In that file you will find the SQL that you are looking for. If you wish, you can add your own sql to the file to look for information across a database link.
To answer the question, the column information is derived from either USER_TAB_COLUMNS or ALL_TAB_COLUMNS.