CREATE TABLE "&1"."PLUTO_TAXLOT_MASTER"
(
"MAXIT_TRANSACTION_LOT_ID" NUMBER(32,0),
"RELATED_LOT_ID" NUMBER(32,0),
"ACCOUNT" VARCHAR2(39 BYTE),
"FIRM" VARCHAR2(32 BYTE),
"SUBSIDARY" VARCHAR2(32 BYTE),
"OPEN_CLOSED" VARCHAR2(1 BYTE),
"UPDATE_TYPE" VARCHAR2(1 BYTE),
"TRAN_TYPE" VARCHAR2(32 BYTE),
"CUSIP" VARCHAR2(30 BYTE),
"SECURITY_NUMBER" VARCHAR2(30 BYTE),
"QUANTITY" NUMBER(30,8),
"SYMBOL" VARCHAR2(30 BYTE),
"ACQUISITION_DATE" DATE,
"ORIGINAL_COST" NUMBER(30,8),
"ADJUSTED_COST" NUMBER(30,8),
"ORIGINAL_PRICE" NUMBER(30,8),
"TRADE_NUMBER" VARCHAR2(80 BYTE),
"DISPOSITION_DATE" DATE,
"DISPOSITION_PRICE" NUMBER(30,8),
"LONG_TERM_GAIN_LOSS" NUMBER(30,8),
"SHORT_TERM_GAIN_LOSS" NUMBER(30,8),
"METHOD" VARCHAR2(32 BYTE),
"SECURITY_DESCRIPTION" VARCHAR2(256 BYTE),
"LONG_SHORT_POSITION" VARCHAR2(1 BYTE),
"PROCEEDS" NUMBER(30,8),
"HOLDING_DATE" DATE,
"COVERED_UNCOVERED" VARCHAR2(1 BYTE),
"SETTLEMENT_DATE" DATE,
"OPEN_FACTOR" NUMBER(30,8),
"CLOSE_FACTOR" NUMBER(30,8),
"EFFECTIVE_DATE" DATE,
"UNIT_COST" NUMBER(30,8),
"FMV" NUMBER(30,8),
"GIFT_DATE" DATE,
"ORIGINAL_PROCEEDS" NUMBER(30,8),
"BUY_TRADE_NUMBER" VARCHAR2(80 BYTE),
"AGENT_FIRM" VARCHAR2(8 BYTE),
"CURRENCY_CODE" VARCHAR2(7 BYTE),
"REINV_IND" VARCHAR2(1 BYTE),
"TRAN_INIT_DATE" DATE,
"CERT_NUM_PFX" VARCHAR2(8 BYTE),
"CERT_NUM" VARCHAR2(12 BYTE),
"BASIS_SHP" VARCHAR2(1 BYTE),
"EXCHANGE_RATE" NUMBER(18,9),
"UNCVR_PNDN_IND" VARCHAR2(1 BYTE),
"ZERO_BASIS_IND" VARCHAR2(2 BYTE),
"TAX_RPT_AGNT" VARCHAR2(1 BYTE),
"ORIG_ACQUI_DATE" DATE,
"ACCT_TYPE" NUMBER(4,0),
"REALIZED_CLOSING_FLAG" VARCHAR2(1 BYTE),
"OPENING_TRANSACTION_EVENT_ID" VARCHAR2(32 BYTE),
"CLOSING_TRANSACTION_EVENT_ID" VARCHAR2(32 BYTE),
"WASH_SALE_IND" VARCHAR2(1 BYTE),
"WASHSALE_BUY_TXN_ID" VARCHAR2(32 BYTE),
"OPEN_SETTLE_CYMD" VARCHAR2(8 BYTE),
"ORIGINAL_TRAN_TYPE" VARCHAR2(32 BYTE),
"ORIGINAL_EVENT_ID" VARCHAR2(32 BYTE),
"DISALLOWED_WASHSALE_AMT" NUMBER(30,8),
"MAXIT_IFCE_SEQ_ID" VARCHAR2(19 BYTE),
"MAXIT_REL_IFCE_SEQ_ID" VARCHAR2(19 BYTE),
"SEDOL" VARCHAR2(7 BYTE), --apire new colomn start
"ISIN_ID" VARCHAR2(15 BYTE),
"CONTROL_ID" VARCHAR2(20 BYTE),
"IN_OUT_FIRM_TYPE" VARCHAR2(36 BYTE),
"RELATED_ACCT" VARCHAR2(30),
"PUT_CALL_IND" VARCHAR2(1),
"EXPIRE_CYMD" VARCHAR2(8 BYTE),
"STRIKE_PRX" NUMBER(22,8),
"ACAT_SEQ_NUM" NUMBER(6,0),
"EXCHANGE_RATE_FMV" NUMBER(18,9),
"ORIGINAL_QUANTITY" NUMBER(25,9),
"UNDERLYING_SEC" VARCHAR2(20 BYTE),
"ISIN_COUNTRY_CODE" VARCHAR2(2 BYTE),
"ISIN_CHK_DIGIT" VARCHAR2(1 BYTE),
"LOSS_NOT_ALLOWED" VARCHAR2(4 BYTE),
"TXN_EVENT_ID" VARCHAR2(32 BYTE),
"TAX_FLAG" VARCHAR2(4 BYTE), --apire new colomn end
"DATA_ORIGIN" VARCHAR2(32 BYTE),
"OPEN_EFFECTIVE_DATE" DATE,
"BAC" NUMBER(30,8),
"PREMIUM" NUMBER(30,8),
"RECORD_CREATED_DATE" DATE DEFAULT sysdate,
"RECORD_VERIFIED_DATE" DATE,
"RECORD_UPDATED_DATE" DATE,
"NULL_FLAG" VARCHAR2(1 BYTE),
"ACATTYPE" VARCHAR2(12 BYTE),
"TERM_INDICATOR" VARCHAR2(5 BYTE),
"SOURCE" VARCHAR2(15 BYTE),
"MTYPE" VARCHAR2(10 BYTE),
"CLIENT_ID" VARCHAR2(3 BYTE),
"BRANCH_CD" VARCHAR2(8 BYTE),
"SEC_TYPE" VARCHAR2(1 BYTE),
"WS_ADJUSTMENT" NUMBER(30,8),
"UNADJUST_COST" NUMBER(30,8),
"PRINCIPAL" NUMBER(30,8),
"COMM" NUMBER(30,8),
"OPEN_CURRENCY_CODE" VARCHAR2(7 BYTE),
"OPEN_EXCHANGE_RATE" NUMBER(18,9),
"IS_ALL_INTEREST_OID" VARCHAR2(100),
"IS_TO_AMR_BPR" CHAR(1) ,
"IS_MDC_CY" CHAR(1) ,
"IS_MDCI" CHAR(1) ,
"IS_SRC" CHAR(1) ,
"NQSI_IND" VARCHAR2(1) ,
"LTD_OID_ACCRUAL" NUMBER ,
"LTD_ACC_PREM" NUMBER ,
"LTD_BOND_PREM" NUMBER ,
"LAST_ADJ_DATE" VARCHAR2(8) ,
"CARRY_OFFSET" NUMBER ,
"DISALLOWED_CARRY_OFFSET" VARCHAR2(100) ,
"LTD_MKT_DISCOUNT" NUMBER ,
"LTD_DEFFERED_INT" NUMBER ,
"LTD_PRIN_PAY" NUMBER ,
"PRY_OID_ACCRUAL" NUMBER ,
"PRY_ACC_PREM" NUMBER ,
"PRY_BOND_PREM" NUMBER ,
"PRY_MKT_DISCOUNT" NUMBER ,
"PRY_DEFFERED_INT" NUMBER ,
"PRY_PRIN_PAY" NUMBER ,
"ACAT_SEQ_NO" NUMBER ,
CONSTRAINT "PK_PLUTO_TAXLOT_MASTER" PRIMARY KEY ("ACCOUNT", "MAXIT_TRANSACTION_LOT_ID", "RELATED_LOT_ID") USING INDEX PCTFREE 10 INITRANS 32 MAXTRANS 255 STORAGE( BUFFER_POOL DEFAULT) LOCAL (PARTITION "P01" TABLESPACE PLUTO_&1._INDEX01, PARTITION "P02" TABLESPACE PLUTO_&1._INDEX02, PARTITION "P03" TABLESPACE PLUTO_&1._INDEX03, PARTITION "P04" TABLESPACE PLUTO_&1._INDEX04, PARTITION "P05" TABLESPACE PLUTO_&1._INDEX05, PARTITION "P06" TABLESPACE PLUTO_&1._INDEX06, PARTITION "P07" TABLESPACE PLUTO_&1._INDEX07, PARTITION "P08" TABLESPACE PLUTO_&1._INDEX08, PARTITION "P09" TABLESPACE PLUTO_&1._INDEX09, PARTITION "P10" TABLESPACE PLUTO_&1._INDEX10, PARTITION "P11" TABLESPACE PLUTO_&1._INDEX11, PARTITION "P12" TABLESPACE PLUTO_&1._INDEX12, PARTITION "P13" TABLESPACE PLUTO_&1._INDEX13, PARTITION "P14" TABLESPACE PLUTO_&1._INDEX14, PARTITION "P15" TABLESPACE PLUTO_&1._INDEX15, PARTITION "P16" TABLESPACE PLUTO_&1._INDEX16) ENABLE
)
PCTFREE 10 PCTUSED 40 INITRANS 32 MAXTRANS 255 STORAGE
(
MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT
)
TABLESPACE PLUTO_&1._DATA00 PARTITION BY LIST
(
"ACCOUNT"
)
(
PARTITION "P01" VALUES('7PY620') TABLESPACE PLUTO_&1._DATA01,
PARTITION "P02" VALUES('737RH0') TABLESPACE PLUTO_&1._DATA02,
PARTITION "P03" VALUES('7375M0') TABLESPACE PLUTO_&1._DATA03,
PARTITION "P04" VALUES('7390D0') TABLESPACE PLUTO_&1._DATA04,
PARTITION "P05" VALUES('738HX0') TABLESPACE PLUTO_&1._DATA05,
PARTITION "P06" VALUES('737EX0') TABLESPACE PLUTO_&1._DATA06,
PARTITION "P07" VALUES('737HX0') TABLESPACE PLUTO_&1._DATA07,
PARTITION "P08" VALUES('70MHF0', '73Y2F0', '7P0130') TABLESPACE PLUTO_&1._DATA08,
PARTITION "P09" VALUES('7P0070', '739EY0', '737VH0') TABLESPACE PLUTO_&1._DATA09,
PARTITION "P10" VALUES('736P60', '7399E0', '707430', '736X10', '737AY0', '7P6NE0', '737F90', '7P6GF0', '2WK8M0', '738V50', '7P6NF0') TABLESPACE PLUTO_&1._DATA10,
PARTITION "P11" VALUES('737RK0', '737VG0', '7375N0', '739060', '70EH00', '70KVN0' ,'70MMM0', '70KVM0', '738XP0') TABLESPACE PLUTO_&1._DATA11,
PARTITION "P12" VALUES('73Y220', '7370W0', '7P6D80', '736360', '7P6PM0', '7P1420', '7PY5V0', '7377E0', '7PY1A0', '7P0030', '737100') TABLESPACE PLUTO_&1._DATA12,
PARTITION "P13" VALUES('7365V0', '70MG50', '7P6D60', '738P10', '73Y2N0', '7369V0', '736370', '7396A0', '736350', '7P0000', '73Y280', '70MMP0', '7368R0', '70KVK0') TABLESPACE PLUTO_&1._DATA13,
PARTITION "P14" VALUES('7375P0', '739550', '7P6D70', '7P1680', '737V00', '7364N0', '73Y2H0', '7P3610', '7P1610', '7P55H0', '7P1580', '737MT0', '2TVFV0') TABLESPACE PLUTO_&1._DATA14,
PARTITION "P15" VALUES('737T60', '7PY2G0', '70MA00', '7P6610', '736R20', '2W8PA0', '7P6A80', '73Y2G0', '739640', '7P75Y0', '7P0220', '7P6GE0') TABLESPACE PLUTO_&1._DATA15,
PARTITION "P16" VALUES(DEFAULT) TABLESPACE PLUTO_&1._DATA16
) ;
CREATE INDEX "&1"."IX1_PLUTO_TAXLOT_MASTER" ON "&1"."PLUTO_TAXLOT_MASTER"
(
"ACCOUNT",
"SECURITY_NUMBER"
)
PCTFREE 10 INITRANS 32 MAXTRANS 255 STORAGE
(
BUFFER_POOL DEFAULT
)
LOCAL
(
PARTITION "P01" TABLESPACE PLUTO_&1._INDEX01,
PARTITION "P02" TABLESPACE PLUTO_&1._INDEX02,
PARTITION "P03" TABLESPACE PLUTO_&1._INDEX03,
PARTITION "P04" TABLESPACE PLUTO_&1._INDEX04,
PARTITION "P05" TABLESPACE PLUTO_&1._INDEX05,
PARTITION "P06" TABLESPACE PLUTO_&1._INDEX06,
PARTITION "P07" TABLESPACE PLUTO_&1._INDEX07,
PARTITION "P08" TABLESPACE PLUTO_&1._INDEX08,
PARTITION "P09" TABLESPACE PLUTO_&1._INDEX09,
PARTITION "P10" TABLESPACE PLUTO_&1._INDEX10,
PARTITION "P11" TABLESPACE PLUTO_&1._INDEX11,
PARTITION "P12" TABLESPACE PLUTO_&1._INDEX12,
PARTITION "P13" TABLESPACE PLUTO_&1._INDEX13,
PARTITION "P14" TABLESPACE PLUTO_&1._INDEX14,
PARTITION "P15" TABLESPACE PLUTO_&1._INDEX15,
PARTITION "P16" TABLESPACE PLUTO_&1._INDEX16
) ;
Oracle 创建 table 例子
最新推荐文章于 2024-08-19 13:32:03 发布