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.
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 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.