TRANSPORT_REQUEST

Definition


The TRANSPORT_REQUEST table contains the list of transport requests created in the system

Technical Data


Schema Version 4.5.13
Tablespace CATALOG_DATA
Partitioned No

Summary


The TRANSPORT_REQUEST table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
OID PK_TRANSPORT_REQUEST        TRAN_DESTINATION (TRAN_OID)
 
CREATION_DATE          
STATUS          
CHAN_OID          
FAILURE_MESSAGE          

Column Details


OID

Definition The unique identifier of the transport request
Type DECIMAL(28), NOT NULL
Primary Key PK_TRANSPORT_REQUEST

CREATION_DATE

Definition The date when the transport request was created
Type DATE, NOT NULL

STATUS

Definition The status of the execution of the transport request
Format

The possible values are:

  • 0: created
  • 1: executed

Type DECIMAL(1), NOT NULL

CHAN_OID

Definition The unique identifier of the related change list
Type DECIMAL(28), NOT NULL

FAILURE_MESSAGE

Definition The failure message if the execution of the transport request failed
Type VARCHAR2(2000 CHAR), NULL

Primary Key Details


PK_TRANSPORT_REQUEST

Column(s) OID
Tablespace CATALOG_INDX