Tuesday, September 23, 2014

XMLTYPE tables do not show up in DBA_TABLES

While researching a potential performance problem in our system as a result of an e-mail from one of my co-workers, I found out that XMLTYPE tables are not really tables at all.  What makes me say that?  Well, check out this My Oracle Support note "Why Xmltype tables don't show up in Dba_tables view?" found via article ID 1419203.1 to find out which view these tables actually show up in and the reason why too!

No comments:

Post a Comment