DBA Data[Home] [Help] [Dependency Information]

TABLE: BEN.BEN_DM_MIGRATIONS

Object Details
Object Name: BEN_DM_MIGRATIONS
Object Type: TABLE
Owner: BEN
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BEN_DM_MIGRATIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMIGRATION_ID
Columns
Name Datatype Length Mandatory Comments
MIGRATION_ID NUMBER (15) Yes Primary Key
MIGRATION_NAME VARCHAR2 (80) Yes User entered name of the Migration
SOURCE_MIGRATION_ID NUMBER (15)
INPUT_PARAMATER_FILE_NAME VARCHAR2 (30) Yes Input Parameter File Name
INPUT_PARAMETER_FILE_PATH VARCHAR2 (60) Yes Input Parameter File Path
DATA_FILE_NAME VARCHAR2 (30)
Data File Name
DATA_FILE_PATH VARCHAR2 (60)
Data File Path
MIGRATION_START_DATE DATE

Start Date of the Migration
MIGRATION_END_DATE DATE

STATUS VARCHAR2 (30) Yes Migration Status
MIGRATION_TYPE VARCHAR2 (30)
Migration Type
DATABASE_LOCATION VARCHAR2 (30) Yes Database Location - (S)ource or (D)estination
EFFECTIVE_DATE DATE

MIGRATION_COUNT NUMBER (15)
LAST_UPDATE_DATE DATE

WHO column
LAST_UPDATED_BY NUMBER (15)
WHO column
LAST_UPDATE_LOGIN NUMBER (15)
WHO column
CREATED_BY NUMBER (15)
WHO column
CREATION_DATE DATE

WHO column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MIGRATION_ID
,      MIGRATION_NAME
,      SOURCE_MIGRATION_ID
,      INPUT_PARAMATER_FILE_NAME
,      INPUT_PARAMETER_FILE_PATH
,      DATA_FILE_NAME
,      DATA_FILE_PATH
,      MIGRATION_START_DATE
,      MIGRATION_END_DATE
,      STATUS
,      MIGRATION_TYPE
,      DATABASE_LOCATION
,      EFFECTIVE_DATE
,      MIGRATION_COUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM BEN.BEN_DM_MIGRATIONS;

Dependencies

[top of page]

BEN.BEN_DM_MIGRATIONS does not reference any database object

BEN.BEN_DM_MIGRATIONS is referenced by following:

SchemaBEN
ViewBEN_DM_MIGRATIONS#