That Darned "CAT"-alogue

There have been quite a number of searches for information on many of the exu8 views present in an Oracle data dictionary. Such views belong to the export/import catalog, created with the $ORACLE_HOME/rdbms/admin/catexp.sql script. Inside this script, in the internal documentation, lies descriptions of many of these views. Let's look at a few which have made the 'Hit Parade' in Google searches:

exu8poki

 This view contains the partitioning key columns for partitioned indexes.

exu8jbq

 Contains job queue entries.

exu8rif

 Contains information on referential contraints.

exu8snapl

 Snapshot log information

exu81obj

 This view selects all rows from sys.obj$ that are NOT secondary
 objects as created by Domain Indexes. Secondary objects are not normally
 exported because the domain index's CREATE INDEX at import time will create
 them.
 

I won't cover any more of these views, as you can easily look in the creation script and find descriptions for almost all of the export/import views.

Happy reading.