Connected to Oracle9i Enterprise Edition Release 9.2.0.7.0
Connected as cal_obx
SQL>
SQL> create table FS_HZ_591_0710_OTHER
2(
3TABLE_TYPENUMBER,
4TICKET_ID NUMBER(15),
5SWITCH_ID NUMBER(9),
6SERV_ID NUMBER(12),
7COLLECT_CDR_IDNUMBER(15),
8BILLING_NBR VARCHAR2(30),
9CALLING_ORG_NBR VARCHAR2(50),
10CALLED_ORG_NBRVARCHAR2(50),
11PROCESS_STAMP VARCHAR2(500),
12START_TIMEDATE,
13CHARGE
NUMBER,
14CHARGE_2NUMBER,
15DISCT_CHARGENUMBER,
16DISCT_CHARGE_2NUMBER,
17FLAG
NUMBER,
18RAMARK
VARCHAR2(500)
19)
SQL> partition by range (TABLE_TYPE)
2(
3partition PART_0710_1 values less than (1)
4tablespace TBS_TCK_DATA
5pctfree 10
6initrans 1
7maxtrans 255
8storage
9(
10initial 64K
11minextents 1
12maxextents unlimited
13),
14partition PART_0710_2 values less than(2)
15tablespace TBS_TCK_DATA
16pctfree 10
17initrans 1
18maxtrans 255
19storage
20(
21initial 64K
22minextents 1
23maxextents unlimited
24),
25partition PART_0710_3 values less than (3)
26tablespace TBS_TCK_DATA
27pctfree 10
28initrans 1
29maxtrans 255
30storage
31(
32initial 64K
33minextents 1
34maxextents unlimited
35),
36partition PART_0710_4 values less than (4)
37tablespace TBS_TCK_DATA
38pctfree 10
39initrans 1
40maxtrans 255
41storage
42(
43initial 64K
44minextents 1
45maxextents unlimited
46),
47partition PART_0710_5 values less than (5)
48tablespace TBS_TCK_DATA
49pctfree 10
50initrans 1
51maxtrans 255
52storage
53(
54initial 64K
55minextents 1
56maxextents unlimited
57),
58partition PART_0710_6 values less than (6)
59tablespace TBS_TCK_DATA
60pctfree 10
61initrans 1
62maxtrans 255
63storage
64(
65initial 64K
66minextents 1
67maxextents unlimited
68),
69partition PART_0710_7 values less than (7)
70tablespace TBS_TCK_DATA
71pctfree 10
72initrans 1
73maxtrans 255
74storage
75(
76initial 64K
77minextents 1
78maxextents unlimited
79),
80partition PART_0710_8 values less than (8)
81tablespace TBS_TCK_DATA
82pctfree 10
83initrans 1
84maxtrans 255
85storage
86(
87initial 64K
88minextents 1
89maxextents unlimited
90),
91partition PART_0710_9 values less than (9)
92tablespace TBS_TCK_DATA
93pctfree 10
94initrans 1
95maxtrans 255
96storage
97(
98initial 64K
99minextents 1
100maxextents unlimited
101),
102partition PART_0710_10 values less than (10)
103tablespace TBS_TCK_DATA
104pctfree 10
105initrans 1
106maxtrans 255
107storage
108(
109initial 64K
110minextents 1
111maxextents unlimited
112),
113partition PART_0710_11 values less than (11)
114tablespace TBS_TCK_DATA
115pctfree 10
116initrans 1
117maxtrans 255
118storage
119(
120initial 64K
121minextents 1
122maxextents unlimited
123)
124)
125;
partition by range (TABLE_TYPE)
(
partition PART_0710_1 values less than (1)
tablespace TBS_TCK_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
),
partition PART_0710_2 values less than(2)
tablespace TBS_TCK_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
),
partition PART_0710_3 values less than (3)
tablespace TBS_TCK_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
),
partition PART_0710_4 values less than (4)
tablespace TBS_TCK_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
),
partition PART_0710_5 values less than (5)
tablespace TBS_TCK_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
),
partition PART_0710_6 values less than (6)
tablespace TBS_TCK_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
),
partition PART_0710_7 values less than (7)
tablespace TBS_TCK_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
),
partition PART_0710_8 values less than (8)
tablespace TBS_TCK_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
),
partition PART_0710_9 values less than (9)
tablespace TBS_TCK_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
ORA-00900: invalid SQL statement
SQL>
|
