Object List Tab

Use the Object List tab to specify other non-related objects for extraction.

Note: Objects you specify on the Object List tab are extracted only when you select Objects or Both as the items to extract on the General tab.
Object List tab selected on Extract Request Editor

Qualifier

The two-part qualifier serves as a prefix to unqualified object names in the Object List. To select from a list of the most recently used qualifiers, click the down arrow. To select a qualifier that is not on the list, click the browse button. The Default Qualifier consists of:

dbalias
Alias of the database in which an object is defined (1 to 12 characters).
creatorid
Creator ID assigned to the object (1 to 64 characters).

Object

Type
The type of object to extract: Default, Function, Package, Procedure, Rule, Sequence, UDT, or View. Click the grid cell to display a down arrow, then click the down arrow to select from a list. You must specify an object type for each entry. The last line in the grid can remain blank.

To clear entries, right-click a grid cell and select Remove or Remove All from the shortcut menu.

To add objects, right-click a grid cell, select Add, then select the object type from the submenu. You can drag an object name from the Select dialog to any line in the grid. The type, name, and status are inserted in the list. You can also add objects to the list manually.

Name
Name of the explicit object to extract. You cannot specify duplicate object names for the same type object. The fully qualified object name consists of:
dbalias
Identifies the database where the object resides.
creatorid
Creator ID assigned to the object.
objectname
Base object name.

Status

The status of the listed object.

Defined
Object exists in the database.
Inaccessible
Cannot connect to the database indicated by the DB Alias.
Incomplete
Object type is not specified, or the object name is not fully qualified. Select an object type, or specify a Qualifier or a three-part object name, as appropriate.
Pending
When you select an object type, the object is pending until you specify an object name.
Unavailable
Object type is not supported for the specified DB Alias (DBMS type).
Unknown
Object does not exist. To create an object, use the Create Utility.

Ignore Unknown Objects

Select this check box to ignore Unknown or Unavailable objects when you run the Extract Request. If you clear this check box, the status of all objects must be Defined to save or run the Extract Request.