1. Tables and Views for Common Features
  2. ADF_SB_REPOSITORIES

ADF_SB_REPOSITORIES

Stores details of each of the Sandboxed Repositories.

Details

  • Schema: FUSION

  • Object owner: ADF

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ADF_SB_RESPOSITORIES_PK

SANDBOX_ID, REPOSITORY_ID

Columns

Name Datatype Length Precision Not-null Comments
SANDBOX_ID VARCHAR2 32 Yes SANDBOX_ID
REPOSITORY_ID VARCHAR2 240 Yes REPOSITORY_ID
CERTIFIED_BASELINE_ID NUMBER 18 CERTIFIED_BASELINE_ID
REPOSITORY_BASELINE VARCHAR2 400 REPOSITORY_BASELINE
REPOSITORY_STATUS VARCHAR2 30 Yes REPOSITORY_STATUS
PUBLISH_LABEL VARCHAR2 80 PUBLISH_LABEL
ERROR_MESSAGE VARCHAR2 4000 ERROR_MESSAGE
BRANCH_DATE TIMESTAMP BRANCH_DATE
PROGRESS VARCHAR2 4000 PROGRESS
LAST_REFRESH_DATE TIMESTAMP LAST_REFRESH_DATE
TRANSACTION_ID VARCHAR2 400 Transaction Id for suspended refresh operation awaiting user interaction.
OP_CHANGE_HINT VARCHAR2 1 Flag to indicate the user's decision on sandbox refresh conflict resolution.
OP_LOCK_INFO VARCHAR2 64 Name of the lock for refresh/publish.
OP_TARGET_BASELINE_ID NUMBER 18 Target Baseline. Key to ADF_SB_REPOSITORY_BASELINES.
CHANGE_LOG_ID NUMBER 18 Change Long Id. Key to ADF_SB_LOGS.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
ADF_SB_REPOSITORIES_U1 Unique Default SANDBOX_ID, REPOSITORY_ID