Object List Tab, Archive Request Editor

Use this tab to specify database objects that are not selected automatically for archiving. Depending on the DBMS, certain objects might not be automatically included.

Archive Request Editor with Object List as the active tab. The elements of the Object List tab are explained as follows.

Default 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 archive: 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 click Remove or Remove All from the shortcut menu.

To add objects, right-click a grid cell, and click Add > the object type in the shortcut menu. You can drag an object name from the Select dialog 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 archive. You cannot specify duplicate object names for the same object type. 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 status 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

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