create table ,data limit check

EXEC pkg_dwh_common_proc.stpr_dwh_drop_tbl('tbl_maprg_pp_vst_usr_maint_u', 'N');

CREATE TABLE tbl_maprg_pp_vst_usr_maint_u
(
month                number(6,0) unique NOT NULL, --整数
txn_amt              number NOT NULL,
guest_vst_amt_usd    number NOT NULL,
guest_vst_amt_cny    number NOT NULL,
pnlty_amt            number NOT NULL,
APROV_FLG            VARCHAR2(1),
APROV_BY             VARCHAR2(30),
APROV_TS             DATE,
LST_UPDATED_BY       VARCHAR2(30),
LST_UPDATED_TS       DATE,
check(month>200000 and month<300000)
)
pctfree 0
tablespace TBS_MAPG_OUT_MEDIUM
nologging;

commit;