dbTalk Databases Forums  

Strange Table entities in oracle database

comp.databases comp.databases


Discuss Strange Table entities in oracle database in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tommaso Gastaldi
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.