-- Oracle 源端
CREATE TABLE "TESTUSER"."T_UMP_SUPPLIER_STATUS_VIEW" 
   (	"ID" VARCHAR2(44), 
	"SMS_CODE" VARCHAR2(50), 
	"CHANNE_NO" VARCHAR2(20), 
	"SEND_DATE" VARCHAR2(10), 
	"SEND_TIME" VARCHAR2(8), 
	"STATUS" VARCHAR2(10), 
	"DELIVRD" NVARCHAR2(200), 
	"SERVICE_TYPE" VARCHAR2(50), 
	"SUPPLIER_NO" VARCHAR2(20), 
	"WHEN_LONG" VARCHAR2(20), 
	"CREATE_DATE" TIMESTAMP (6), 
	 CONSTRAINT "PK_SUPPLIERID" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SMSTBS"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SMSTBS" 
  PARTITION BY RANGE ("CREATE_DATE") INTERVAL (NUMTODSINTERVAL(1,'DAY')) 
 (PARTITION "P201904"  VALUES LESS THAN (TIMESTAMP' 2019-04-21 00:00:00') SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SMSTBS" );

CREATE INDEX "TESTUSER"."IDX1_UMP_SUPPLIER_STATUS_VIEW" ON "TESTUSER"."T_UMP_SUPPLIER_STATUS_VIEW" ("CREATE_DATE") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IX_TBS"  LOCAL
 (PARTITION "P201904" 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IX_TBS" );
CREATE INDEX "TESTUSER"."IDX2_UMP_SUPPLIER_STATUS_VIEW" ON "TESTUSER"."T_UMP_SUPPLIER_STATUS_VIEW" ("SEND_DATE") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IX_TBS"  LOCAL
 (PARTITION "P201904" 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IX_TBS" );
CREATE INDEX "TESTUSER"."IDX3_UMP_SUPPLIER_STATUS_VIEW" ON "TESTUSER"."T_UMP_SUPPLIER_STATUS_VIEW" ("SMS_CODE") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IX_TBS"  LOCAL
 (PARTITION "P201904" 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IX_TBS" );









-- 目标端 oceanbase oracle 模式
CREATE TABLE "TESTUSER"."T_HIS_SUPPLIER_STATUS_VIEW_BAK" (
  "ID" VARCHAR2(44),
  "SMS_CODE" VARCHAR2(50),
  "CHANNE_NO" VARCHAR2(20),
  "SEND_DATE" VARCHAR2(10),
  "SEND_TIME" VARCHAR2(8),
  "STATUS" VARCHAR2(10),
  "DELIVRD" NVARCHAR2(200),
  "SERVICE_TYPE" VARCHAR2(50),
  "SUPPLIER_NO" VARCHAR2(20),
  "WHEN_LONG" VARCHAR2(20),
  "CREATE_DATE" TIMESTAMP(6)
) COMPRESS FOR ARCHIVE REPLICA_NUM = 2 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
 partition by range(CREATE_DATE)
(partition "P01" values less than (Timestamp '2018-05-01 00:00:00.000000'),
partition "P201906" values less than (Timestamp '2019-07-01 00:00:00.000000'),
partition "P201907" values less than (Timestamp '2019-08-01 00:00:00.000000'),
partition "P201908" values less than (Timestamp '2019-09-01 00:00:00.000000'),
partition "P201909" values less than (Timestamp '2019-10-01 00:00:00.000000'),
partition "P201910" values less than (Timestamp '2019-11-01 00:00:00.000000'),
partition "P201911" values less than (Timestamp '2019-12-01 00:00:00.000000'),
partition "P201912" values less than (Timestamp '2020-01-01 00:00:00.000000'),
partition "P202001" values less than (Timestamp '2020-02-01 00:00:00.000000'),
partition "P202002" values less than (Timestamp '2020-03-01 00:00:00.000000'),
partition "P202003" values less than (Timestamp '2020-04-01 00:00:00.000000'),
partition "P202004" values less than (Timestamp '2020-05-01 00:00:00.000000'),
partition "P202005" values less than (Timestamp '2020-06-01 00:00:00.000000'),
partition "P202006" values less than (Timestamp '2020-07-01 00:00:00.000000'),
partition "P202007" values less than (Timestamp '2020-08-01 00:00:00.000000'),
partition "P202008" values less than (Timestamp '2020-09-01 00:00:00.000000'),
partition "P202009" values less than (Timestamp '2020-10-01 00:00:00.000000'),
partition "P202010" values less than (Timestamp '2020-11-01 00:00:00.000000'),
partition "P202011" values less than (Timestamp '2020-12-01 00:00:00.000000'),
partition "P202012" values less than (Timestamp '2021-01-01 00:00:00.000000'),
partition "P202101" values less than (Timestamp '2021-02-01 00:00:00.000000'),
partition "P202102" values less than (Timestamp '2021-03-01 00:00:00.000000'),
partition "P202103" values less than (Timestamp '2021-04-01 00:00:00.000000'),
partition "P202104" values less than (Timestamp '2021-05-01 00:00:00.000000'),
partition "P202105" values less than (Timestamp '2021-06-01 00:00:00.000000'),
partition "P202106" values less than (Timestamp '2021-07-01 00:00:00.000000'),
partition "P202107" values less than (Timestamp '2021-08-01 00:00:00.000000'),
partition "P202108" values less than (Timestamp '2021-09-01 00:00:00.000000'),
partition "P202109" values less than (Timestamp '2021-10-01 00:00:00.000000'),
partition "P202110" values less than (Timestamp '2021-11-01 00:00:00.000000'),
partition "P202111" values less than (Timestamp '2021-12-01 00:00:00.000000'),
partition "P202112" values less than (Timestamp '2022-01-01 00:00:00.000000'),
partition "P202201" values less than (Timestamp '2022-02-01 00:00:00.000000'),
partition "P202202" values less than (Timestamp '2022-03-01 00:00:00.000000'),
partition "P202203" values less than (Timestamp '2022-04-01 00:00:00.000000'),
partition "P202204" values less than (Timestamp '2022-05-01 00:00:00.000000'),
partition "P202205" values less than (Timestamp '2022-06-01 00:00:00.000000'),
partition "P202206" values less than (Timestamp '2022-07-01 00:00:00.000000'),
partition "P202207" values less than (Timestamp '2022-08-01 00:00:00.000000'),
partition "P202208" values less than (Timestamp '2022-09-01 00:00:00.000000'),
partition "P202209" values less than (Timestamp '2022-10-01 00:00:00.000000'),
partition "P202210" values less than (Timestamp '2022-11-01 00:00:00.000000'),
partition "P202211" values less than (Timestamp '2022-12-01 00:00:00.000000'),
partition "P202212" values less than (Timestamp '2023-01-01 00:00:00.000000'),
partition "P202301" values less than (Timestamp '2023-02-01 00:00:00.000000'),
partition "P202302" values less than (Timestamp '2023-03-01 00:00:00.000000'),
partition "P202303" values less than (Timestamp '2023-04-01 00:00:00.000000'),
partition "P202304" values less than (Timestamp '2023-05-01 00:00:00.000000'),
partition "P202305" values less than (Timestamp '2023-06-01 00:00:00.000000'),
partition "P202306" values less than (Timestamp '2023-07-01 00:00:00.000000'),
partition "P202307" values less than (Timestamp '2023-08-01 00:00:00.000000'),
partition "P202308" values less than (Timestamp '2023-09-01 00:00:00.000000'),
partition "P202309" values less than (Timestamp '2023-10-01 00:00:00.000000'),
partition "P202310" values less than (Timestamp '2023-11-01 00:00:00.000000'),
partition "P202311" values less than (Timestamp '2023-12-01 00:00:00.000000'),
partition "P202312" values less than (Timestamp '2024-01-01 00:00:00.000000'),
partition "P202401" values less than (Timestamp '2024-02-01 00:00:00.000000'),
partition "P202402" values less than (Timestamp '2024-03-01 00:00:00.000000'),
partition "P202403" values less than (Timestamp '2024-04-01 00:00:00.000000'),
partition "P202404" values less than (Timestamp '2024-05-01 00:00:00.000000'),
partition "P202405" values less than (Timestamp '2024-06-01 00:00:00.000000'),
partition "P202406" values less than (Timestamp '2024-07-01 00:00:00.000000'),
partition "P202407" values less than (Timestamp '2024-08-01 00:00:00.000000'),
partition "P202408" values less than (Timestamp '2024-09-01 00:00:00.000000'),
partition "P202409" values less than (Timestamp '2024-10-01 00:00:00.000000'),
partition "P202410" values less than (Timestamp '2024-11-01 00:00:00.000000'),
partition "P202411" values less than (Timestamp '2024-12-01 00:00:00.000000'),
partition "P202412" values less than (Timestamp '2025-01-01 00:00:00.000000'),
partition "P202501" values less than (Timestamp '2025-02-01 00:00:00.000000'),
partition "P202502" values less than (Timestamp '2025-03-01 00:00:00.000000'),
partition "P202503" values less than (Timestamp '2025-04-01 00:00:00.000000'),
partition "P202504" values less than (Timestamp '2025-05-01 00:00:00.000000'),
partition "P202505" values less than (Timestamp '2025-06-01 00:00:00.000000'),
partition "P202506" values less than (Timestamp '2025-07-01 00:00:00.000000'),
partition "P202507" values less than (Timestamp '2025-08-01 00:00:00.000000'),
partition "P202508" values less than (Timestamp '2025-09-01 00:00:00.000000'),
partition "P202509" values less than (Timestamp '2025-10-01 00:00:00.000000'),
partition "P202510" values less than (Timestamp '2025-11-01 00:00:00.000000'),
partition "P202511" values less than (Timestamp '2025-12-01 00:00:00.000000'),
partition "P202512" values less than (Timestamp '2026-01-01 00:00:00.000000'));

CREATE INDEX "TESTUSER"."IDX01_SUPPLIER_STATUS_VIEW_BAK" on "TESTUSER"."T_HIS_SUPPLIER_STATUS_VIEW_BAK" (
 "SMS_CODE",
 "CREATE_DATE"
) LOCAL ;