Strange Table entities in oracle database -
12-11-2003
, 08:01 AM
I have a question which might be trivial for people familiar with
oracle, but it is not for me.
As you know the oledb driver stores information about the structure of
the database. In particular, 2 tables: "TABLES", "COLUMNS" store
information about the tables and the columns of the database.
(TABLES store the information about: tables, views, links, synonyms)
Having I done a program which scans all the OleDb tables and reconstruct
the entire structure of any database, I have found, Scanning ORACLE/SAP
(about 40.000 tables anf half million columns) that the table of COLUMNS
(fiels of database) lists some columns which belong to tables which are
not listed in the oledb table of TABLES.
Is anybody able to tell me what these tables are and whether they have
are called in a specific way?
Thank in advance for any answer (please send a c/c to
tommaso.gastaldi (AT) uniroma1 (DOT) it)
tommaso
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG |