W RTL Bcost It LC Dy F 30

ALTER TABLE RA_DATA_MART.
W_RTL_BCOST_IT_LC_DY_F
DROP PRIMARY KEY CASCADE;
DROP TABLE RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F CASCADE CONSTRAINTS;
CREATE TABLE RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F

(
ROW_WID NUMBER(10),
PROD_WID NUMBER(10),
PROD_SCD1_WID NUMBER(10),
ORG_WID NUMBER(10),
ORG_DH_WID NUMBER(10),
ORG_SCD1_WID NUMBER(10),
SUPPLIER_WID NUMBER(10),
FROM_DT_WID NUMBER(15),
TO_DT_WID NUMBER(15),
BASE_COST_AMT_LCL NUMBER(20,4),
DM_RECD_STATUS CHAR(1 CHAR),
AUX1_CHANGED_ON_DT DATE,
CHANGED_BY_WID NUMBER(10),
CHANGED_ON_DT DATE,
CREATED_BY_WID NUMBER(10),
CREATED_ON_DT DATE,
DATASOURCE_NUM_ID NUMBER(10),
DELETE_FLG CHAR(1 CHAR),
DOC_CURR_CODE VARCHAR2(30 CHAR),
ETL_PROC_WID NUMBER(10),
GLOBAL1_EXCHANGE_RATE NUMBER(22,7),
INTEGRATION_ID VARCHAR2(80 CHAR),
LOC_CURR_CODE VARCHAR2(30 CHAR),
LOC_EXCHANGE_RATE NUMBER(22,7),
TENANT_ID VARCHAR2(80 CHAR),
W_INSERT_DT DATE,
W_UPDATE_DT DATE,
X_CUSTOM VARCHAR2(10 CHAR)
)
TABLESPACE DM_FACT_DATA
PCTUSED 0
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
LOGGING
PARTITION BY RANGE (FROM_DT_WID)
SUBPARTITION BY HASH (ORG_WID)
(
PARTITION W_RTL_BCOST_IT_LC_DY_F_P001 VALUES LESS THAN (120090705000)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
SUBPARTITIONS 256 STORE IN
(DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_F
ACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_D
ATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,D
M_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FAC
T_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DAT
A,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_
FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_
DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,
DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FA
CT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DA
TA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM
_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT
_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA
,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_FACT_DATA,DM_F
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA),
PARTITION W_RTL_BCOST_IT_LC_DY_F_MAX VALUES LESS THAN (MAXVALUE)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 6
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
ACT_DATA)
)
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
ENABLE ROW MOVEMENT;
CREATE UNIQUE INDEX RA_DATA_MART.PK_W_RTL_BCOST_IT_LC_DY_F ON

RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F
(ORG_DH_WID, PROD_WID, FROM_DT_WID)
NOLOGGING
TABLESPACE RETAIL_DATA
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE INDEX RA_DATA_MART.W_RTL_BCOST_IT__IDX$$_88AE0004 ON

RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F
(FROM_DT_WID, ORG_WID, PROD_WID)
LOGGING
TABLESPACE RETAIL_DATA
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
DROP SYNONYM RA_FE_DATA_MART.W_RTL_BCOST_IT_LC_DY_F;
CREATE OR REPLACE SYNONYM RA_FE_DATA_MART.W_RTL_BCOST_IT_LC_DY_F FOR

RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F;
ALTER TABLE RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F ADD (

CHECK ("ROW_WID" IS NOT NULL),
CHECK ("PROD_WID" IS NOT NULL),
CHECK ("PROD_SCD1_WID" IS NOT NULL),
CHECK ("ORG_WID" IS NOT NULL),
CHECK ("ORG_DH_WID" IS NOT NULL),
CHECK ("ORG_SCD1_WID" IS NOT NULL),
CHECK ("SUPPLIER_WID" IS NOT NULL),
CHECK ("FROM_DT_WID" IS NOT NULL),
CHECK ("TO_DT_WID" IS NOT NULL),
CHECK ("DATASOURCE_NUM_ID" IS NOT NULL),
CHECK ("ETL_PROC_WID" IS NOT NULL),
CHECK ("INTEGRATION_ID" IS NOT NULL),
CONSTRAINT PK_W_RTL_BCOST_IT_LC_DY_F
PRIMARY KEY
(ORG_DH_WID, PROD_WID, FROM_DT_WID)
USING INDEX RA_DATA_MART.PK_W_RTL_BCOST_IT_LC_DY_F);
GRANT DELETE, INSERT, SELECT, UPDATE ON RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F TO

RADM_DAA_ROLE;

RA_BATCH;

RA_FE_DATA_MART;

W RTL Bcost It LC Dy F 30

Uploaded by

Copyright:

Available Formats

W RTL Bcost It LC Dy F 30

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

W RTL Bcost It LC Dy F 30

Uploaded by

Copyright:

Available Formats

ALTER TABLE RA_DATA_MART.

DROP TABLE RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F CASCADE CONSTRAINTS;

CREATE TABLE RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F

CREATE UNIQUE INDEX RA_DATA_MART.PK_W_RTL_BCOST_IT_LC_DY_F ON

CREATE INDEX RA_DATA_MART.W_RTL_BCOST_IT__IDX$$_88AE0004 ON

DROP SYNONYM RA_FE_DATA_MART.W_RTL_BCOST_IT_LC_DY_F;

CREATE OR REPLACE SYNONYM RA_FE_DATA_MART.W_RTL_BCOST_IT_LC_DY_F FOR

ALTER TABLE RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F ADD (

GRANT DELETE, INSERT, SELECT, UPDATE ON RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F TO

GRANT DELETE, INSERT, SELECT, UPDATE ON RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F TO

GRANT DELETE, INSERT, SELECT, UPDATE ON RA_DATA_MART.W_RTL_BCOST_IT_LC_DY_F TO

You might also like