2 -- 创建父表
3 CREATE TABLE jiedian_cause_list_45G (
4 time TIMESTAMP,
5 eci VARCHAR(50),
6 region_name VARCHAR(50),
7 city_name VARCHAR(50),
8 cell_name VARCHAR(200),
9 site_name VARCHAR(200),
10 vendor_name VARCHAR(50),
11 site_id VARCHAR(100),
12 ci VARCHAR(100),
13 net_type VARCHAR(50),
14 ant_channel INTEGER,
15 rru_type VARCHAR(2000),
16 if_white_list VARCHAR(30),
17 symbol_white_list VARCHAR(256),
18 symbolshutdownswitch VARCHAR(128),
19 symbol_config_case VARCHAR(30),
20 rfchannel_white_list VARCHAR(256),
21 rfchannelshutdownswitch VARCHAR(128),
22 rfchannel_config_case VARCHAR(30),
23 rfchannel_white_start VARCHAR(128),
24 acttime_ye_rfchannel_start VARCHAR(128),
25 rfchannel_white_end VARCHAR(128),
26 acttime_ye_rfchannel_end VARCHAR(128),
27 acttime_ri_rfchannel VARCHAR(128),
28 carrier_white_list VARCHAR(256),
29 carriershutdownswitch VARCHAR(128),
30 carrier_config_case VARCHAR(30),
31 carrier_white_start VARCHAR(128),
32 acttime_ye_carrier_start VARCHAR(128),
33 carrier_white_end VARCHAR(128),
34 acttime_ye_carrier_end VARCHAR(128),
35 acttime_ye_carrier VARCHAR(128),
36 deepsleep_white_list VARCHAR(256),
37 deepsleepswitch VARCHAR(128),
38 deepsleep_config_case VARCHAR(30),
39 deepsleep_white_list_start VARCHAR(128),
40 acttime_ye_deepsleep_start VARCHAR(128),
41 deepsleep_white_list_end VARCHAR(128),
42 acttime_ye_deepsleep_end VARCHAR(128),
43 acttime_ri_deepsleep VARCHAR(128),
44 rfchannel_rru_support VARCHAR(50),
45 symbol_rru_support VARCHAR(50),
46 carrier_rru_support VARCHAR(50),
47 deepsleep_rru_support VARCHAR(50),
48 if_new_site VARCHAR(30),
49 carriershutdowntime NUMERIC,
50 deepsleepshutdowntime NUMERIC,
51 carrier_default_time NUMERIC,
52 deepsleep_default_time NUMERIC,
53 white_list_type VARCHAR(300),
54 white_list_right_cofig VARCHAR(300),
55 white_list_wrong_cofig VARCHAR(300),
56 jiedian_switch_using VARCHAR(300),
57 jiedian_switch_closed VARCHAR(300),
58 parameter_reject_type VARCHAR(50),
59 switch_mistake VARCHAR(30),
60 carrier_switch_abnormal VARCHAR(30),
61 deepsleep_switch_abnormal VARCHAR(30),
62 rfchannel_ant_config VARCHAR(30),
63 f_down_5g_rfchannel_on NUMERIC,
64 down_5g_rfchannel_on_def NUMERIC,
65 rfchannel_on_contrast VARCHAR(30),
66 f_down_5g_rfchannel_of NUMERIC,
67 down_5g_rfchannel_of_def NUMERIC,
68 rfchannel_off_contrast VARCHAR(30),
69 f_user_5g_rfchannel_on NUMERIC,
70 user_5g_rfchannel_on_def NUMERIC,
71 user_rfchannel_on_contrast VARCHAR(30),
72 f_user_5g_rfchannel_off NUMERIC,
73 user_5g_rfchannel_off_def NUMERIC,
74 user_rfchannel_off_contrast VARCHAR(30),
75 f_down_5g_carrier_on NUMERIC,
76 down_5g_carrier_on_def NUMERIC,
77 carrier_5g_on_contrast VARCHAR(30),
78 f_down_5g_carrier_of NUMERIC,
79 down_5g_carrier_of_def NUMERIC,
80 carrier_5g_off_contrast VARCHAR(30),
81 f_user_5g_carrier_on NUMERIC,
82 user_5g_carrier_on_def NUMERIC,
83 user_carrier_5g_on_contrast VARCHAR(30),
84 f_user_5g_carrier_off NUMERIC,
85 user_5g_carrier_off_def NUMERIC,
86 user_carrier_5g_off_contrast VARCHAR(30),
87 f_down_4g_carrier_on NUMERIC,
88 down_4g_carrier_on_def NUMERIC,
89 carrier_4g_on_contrast VARCHAR(30),
90 f_down_4g_carrier_of NUMERIC,
91 down_4g_carrier_of_def NUMERIC,
92 carrier_4g_off_contrast VARCHAR(30),
93 f_user_4g_carrier_on NUMERIC,
94 user_4g_carrier_on_def NUMERIC,
95 user_carrier_4g_on_contrast VARCHAR(30),
96 f_user_4g_carrier_off NUMERIC,
97 user_4g_carrier_off_def NUMERIC,
98 user_carrier_4g_off_contrast VARCHAR(30),
99 parameter_anomaly_status VARCHAR(2000)
100 ) PARTITION BY LIST (time);
dmserver.exe D:\work\dmdbms\data\DAMENG\dm.ini
-- 创建父表
CREATE TABLE jiedian_cause_list_45G (
time TIMESTAMP,
eci VARCHAR(50),
region_name VARCHAR(50),
city_name VARCHAR(50),
cell_name VARCHAR(200),
site_name VARCHAR(200),
vendor_name VARCHAR(50),
site_id VARCHAR(100),
ci VARCHAR(100),
net_type VARCHAR(50),
ant_channel INTEGER,
rru_type VARCHAR(2000),
if_white_list VARCHAR(30),
symbol_white_list VARCHAR(256),
symbolshutdownswitch VARCHAR(128),
symbol_config_case VARCHAR(30),
rfchannel_white_list VARCHAR(256),
rfchannelshutdownswitch VARCHAR(128),
rfchannel_config_case VARCHAR(30),
rfchannel_white_start VARCHAR(128),
acttime_ye_rfchannel_start VARCHAR(128),
rfchannel_white_end VARCHAR(128),
acttime_ye_rfchannel_end VARCHAR(128),
acttime_ri_rfchannel VARCHAR(128),
carrier_white_list VARCHAR(256),
carriershutdownswitch VARCHAR(128),
carrier_config_case VARCHAR(30),
carrier_white_start VARCHAR(128),
acttime_ye_carrier_start VARCHAR(128),
carrier_white_end VARCHAR(128),
acttime_ye_carrier_end VARCHAR(128),
acttime_ye_carrier VARCHAR(128),
deepsleep_white_list VARCHAR(256),
deepsleepswitch VARCHAR(128),
deepsleep_config_case VARCHAR(30),
deepsleep_white_list_start VARCHAR(128),
acttime_ye_deepsleep_start VARCHAR(128),
deepsleep_white_list_end VARCHAR(128),
acttime_ye_deepsleep_end VARCHAR(128),
acttime_ri_deepsleep VARCHAR(128),
rfchannel_rru_support VARCHAR(50),
symbol_rru_support VARCHAR(50),
carrier_rru_support VARCHAR(50),
deepsleep_rru_support VARCHAR(50),
if_new_site VARCHAR(30),
carriershutdowntime NUMERIC,
deepsleepshutdowntime NUMERIC,
carrier_default_time NUMERIC,
deepsleep_default_time NUMERIC,
white_list_type VARCHAR(300),
white_list_right_cofig VARCHAR(300),
white_list_wrong_cofig VARCHAR(300),
jiedian_switch_using VARCHAR(300),
jiedian_switch_closed VARCHAR(300),
parameter_reject_type VARCHAR(50),
switch_mistake VARCHAR(30),
carrier_switch_abnormal VARCHAR(30),
deepsleep_switch_abnormal VARCHAR(30),
rfchannel_ant_config VARCHAR(30),
f_down_5g_rfchannel_on NUMERIC,
down_5g_rfchannel_on_def NUMERIC,
rfchannel_on_contrast VARCHAR(30),
f_down_5g_rfchannel_of NUMERIC,
down_5g_rfchannel_of_def NUMERIC,
rfchannel_off_contrast VARCHAR(30),
f_user_5g_rfchannel_on NUMERIC,
user_5g_rfchannel_on_def NUMERIC,
user_rfchannel_on_contrast VARCHAR(30),
f_user_5g_rfchannel_off NUMERIC,
user_5g_rfchannel_off_def NUMERIC,
user_rfchannel_off_contrast VARCHAR(30),
f_down_5g_carrier_on NUMERIC,
down_5g_carrier_on_def NUMERIC,
carrier_5g_on_contrast VARCHAR(30),
f_down_5g_carrier_of NUMERIC,
down_5g_carrier_of_def NUMERIC,
carrier_5g_off_contrast VARCHAR(30),
f_user_5g_carrier_on NUMERIC,
user_5g_carrier_on_def NUMERIC,
user_carrier_5g_on_contrast VARCHAR(30),
f_user_5g_carrier_off NUMERIC,
user_5g_carrier_off_def NUMERIC,
user_carrier_5g_off_contrast VARCHAR(30),
f_down_4g_carrier_on NUMERIC,
down_4g_carrier_on_def NUMERIC,
carrier_4g_on_contrast VARCHAR(30),
f_down_4g_carrier_of NUMERIC,
down_4g_carrier_of_def NUMERIC,
carrier_4g_off_contrast VARCHAR(30),
f_user_4g_carrier_on NUMERIC,
user_4g_carrier_on_def NUMERIC,
user_carrier_4g_on_contrast VARCHAR(30),
f_user_4g_carrier_off NUMERIC,
user_4g_carrier_off_def NUMERIC,
user_carrier_4g_off_contrast VARCHAR(30),
parameter_anomaly_status VARCHAR(2000)
) PARTITION BY LIST (time);
dmserver.exe D:\work\dmdbms\data\DAMENG\dm.ini
*
第 1 行, 第 25 列[D]附近出现错误[-2007]:语法分析出错.
已用时间: 2.638(毫秒). 执行号:0.
SQL>
SQL> -- 创建分区表
2 CREATE TABLE jiedian_cause_list_45G_20250801 PARTITION OF jiedian_cause_list_45G FOR VALUES IN ('2025-08-01 00:00:00');
-- 创建分区表
CREATE TABLE jiedian_cause_list_45G_20250801 PARTITION OF jiedian_cause_list_45G FOR VALUES IN ('2025-08-01 00:00:00');
CREATE TABLE jiedian_cause_list_45G_20250801 PARTITION OF jiedian_cause_list_45G FOR VALUES IN ('2025-08-01 00:00:00');
*
第 2 行, 第 97 列[PARTITION]附近出现错误[-2007]:语法分析出错.
已用时间: 2.160(毫秒). 执行号:0.
SQL> CREATE TABLE jiedian_cause_list_45G_20250802 PARTITION OF jiedian_cause_list_45G FOR VALUES IN ('2025-08-02 00:00:00');
CREATE TABLE jiedian_cause_list_45G_20250802 PARTITION OF jiedian_cause_list_45G FOR VALUES IN ('2025-08-02 00:00:00');
CREATE TABLE jiedian_cause_list_45G_20250802 PARTITION OF jiedian_cause_list_45G FOR VALUES IN ('2025-08-02 00:00:00');
*
第 1 行, 第 96 列[PARTITION]附近出现错误[-2007]:语法分析出错.
已用时间: 0.190(毫秒). 执行号:0.
SQL> CREATE TABLE jiedian_cause_list_45G_20250803 PARTITION OF jiedian_cause_list_45G FOR VALUES IN ('2025-08-03 00:00:00');
CREATE TABLE jiedian_cause_list_45G_20250803 PARTITION OF jiedian_cause_list_45G FOR VALUES IN ('2025-08-03 00:00:00');
CREATE TABLE jiedian_cause_list_45G_20250803 PARTITION OF jiedian_cause_list_45G FOR VALUES IN ('2025-08-03 00:00:00');
*
第 1 行, 第 96 列[PARTITION]附近出现错误[-2007]:语法分析出错.
已用时间: 0.273(毫秒). 执行号:0.
最新发布