To complete specific tasks, the Oracle connector requires
access to a set of Oracle dictionary views.
The following list describes how the Oracle connector
uses each view.
- ALL_CONSTRAINTS
- The Oracle connector accesses this view to obtain the list of
constraints for a table. Obtaining a list of constraints is required
for these tasks: importing a table definition, disabling constraints,
and enabling constraints.
- ALL_INDEXES
- The Oracle connector accesses this view to obtain the list of
indexes for a table. Obtaining this information is required for these
tasks: importing a table definition, determining the list of indexes
to rebuild, and determining how a table is organized, either by heap
or by index.
- ALL_OBJECTS
- The Oracle connector accesses this view to obtain additional metadata,
such as table names and view names, for the objects that the user
specifies. 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
- The Oracle connector accesses this view to determine the boundary
(high) value for each partition in a table. This information is used
in a partitioned write.
- ALL_PART_KEY_COLUMNS
- The Oracle connector accesses this view to determine the list
of columns that are in the partition key for a table. This information
is used in a partitioned write.
- ALL_PART_TABLES
- The Oracle connector accesses this view to determine partitioning
method that the table uses. When the Oracle connector value is specified for the Partition type property, 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.
- ALL_TAB_COLS
- The Oracle connector accesses this view to determine column metadata,
for example data type, length, precision, and scale; to determine
if a column is a virtual column; and to 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.
- ALL_TAB_PARTITIONS
- The Oracle connector accesses this view to determine the number
and names of the partitions in a partitioned table. This information
is required for read and write operations.
- ALL_TAB_SUBPARTITIONS
- The Oracle connector accesses this view to determine the number
and names of all subpartitions in a composite-partitioned table. This
information is required for read and write operations.
- ALL_TABLES
- The Oracle connector accesses this view to determine the list
of tables that are accessible by the current user. Obtaining this
information is required for these tasks: importing a table definition,
determining which users have tables with SYSTEM or SYSAUX table space
as their default table space, and determining if a specified table
is partitioned.
- ALL_VIEWS
- The Oracle connector accesses this view to determine the list
of views that are accessible by the current user. This information
is used to present the user with a list of views that can be imported.
- ALL_XML_TAB_COLS
- To determine the XML storage option that was specified in the
column definitions, the Oracle connector accesses this view during
the metadata import of tables that contain XMLType columns.
- ALL_XML_TABLES
- To determine the XML storage option that was specified in the
table definitions, the Oracle connector accesses this view during
the metadata import of XMLType tables.
- DBA_EXTENTS
- The Oracle connector accesses this view to gather information
about the table storage organization. The connector uses the information
when the Rowid range partitioned read method is selected. If select
access is not granted to this view, the connector automatically switches
to the Rowid hash partitioned read method.
- DUAL
- To obtain and calculate various intermediate values that the connector
needs for its operation, the connector issues SELECT statements on
this table.
- USER_TAB_PRIVS
- The Oracle connector accesses this table to determine if the current
user was granted select privilege on a particular dictionary view,
for example the DBA_EXTENTS view. If the current user was not granted
select privilege, the connector takes corrective action.
IBM InfoSphere Information Server, Version 8.5
This topic is also in the IBM InfoSphere DataStage and QualityStage Connectivity Guide for Oracle Databases.
