Dictionary views

To complete specific tasks, the Oracle connector requires access to a set of Oracle dictionary views.

The following table describes how the Oracle connector uses each dictionary view.
Table 1. How the Oracle connector uses Oracle dictionary views
Dictionary view Use Required for these tasks
ALL_CONSTRAINTS Obtain the list of constraints for a table
  • Importing a table definition
  • Enabling and disabling constraints
ALL_INDEXES Obtain the list of indexes for a table
  • Importing a table definition
  • Determining the list of indexes to rebuild
  • Determining how a table is organized, either as a heap table or by index
ALL_OBJECTS Obtain additional metadata, such as table names and view names, for the objects that you specify Depends on the objects that you specify. For example, for a parallel read that is based on Oracle partitions, the connector accesses this view to determine the object type, either table or view, and the partitions and subpartitions.
ALL_PART_COL_STATISTICS Determine the boundary (high) value for each partition in a table Writing to a partitioned table
ALL_PART_KEY_COLUMNS Determine the list of columns that are in the partition key for a table Writing to a partitioned table
ALL_PART_TABLES Determine the partitioning method that the table uses. When the Oracle connector partition type is selected, the Oracle connector uses the information from this view to determine the partition to which each record belongs and then to direct each record to the node that is associated with that partition. Writing to a partitioned table
ALL_TAB_COLS
  • Determine column metadata such as data type, length, precision, and scale to determine if a column is a virtual column
  • Determine if a column exists and if it is of the correct data type when the Modulus or the Minimum and Maximum range partitioned read method is specified
 Completing actions on a partitioned table
ALL_TAB_PARTITIONS Determine the number and names of the partitions in a partitioned table Completing actions on a partitioned table
ALL_TAB_SUBPARTITIONS Determine the number and names of all subpartitions in a composite-partitioned table Completing actions on a partitioned table
ALL_TABLES Determine the list of tables that are accessible by the current user
  • Importing a table definition
  • Identifying the users that have tables with the SYSTEM or SYSAUX table space as the default table space for the user
  • Determining if a specified table is partitioned
ALL_VIEWS Determine the views that are accessible by the current user Identifying the views that you can import
ALL_XML_TAB_COLS Determine the XML storage option that was specified in the column definitions Importing metadata for tables that contain XMLType columns
ALL_XML_TABLES Determine the XML storage option that was specified in the table definitions Importing metadata for tables that contain XMLType columns
DBA_EXTENTS Gather information about the table storage organization Reading from partitioned tables by using the rowid range partitioned read method. If select access is not granted to this view, the connector automatically switches to the rowid hash partitioned read method.
DUAL Obtain and calculate various intermediate values that the connector needs for its operation Completing actions on a table
USER_TAB_PRIVS Determine if the current user was granted select privilege on a particular dictionary view such as the DBA_EXTENTS view. If the current user was not granted select privilege, the connector takes corrective action. Accessing a dictionary view