partition [message #7833] |
Fri, 11 July 2003 00:24 |
Bala
Messages: 205 Registered: November 1999
|
Senior Member |
|
|
Can anyone tell me what is wrong with the below statement.
SQL> CREATE TABLE sales
2 (s_productid NUMBER,
3 s_saledate DATE,
4 s_custid NUMBER,
5 s_totalprice NUMBER)
6 PARTITION BY RANGE(s_saledate)
7 (PARTITION sal94q1 VALUES LESS THAN TO_DATE (01-APR-1994, DD-MON-YYYY),
8 PARTITION sal94q2 VALUES LESS THAN TO_DATE (01-JUL-1994, DD-MON-YYYY),
9 PARTITION sal94q3 VALUES LESS THAN TO_DATE (01-OCT-1994, DD-MON-YYYY),
10 PARTITION sal94q4 VALUES LESS THAN TO_DATE (01-JAN-1995, DD-MON-YYYY),
11 PARTITION sal95q1 VALUES LESS THAN TO_DATE (01-APR-1995, DD-MON-YYYY),
12 PARTITION sal95q2 VALUES LESS THAN TO_DATE (01-JUL-1995, DD-MON-YYYY),
13 PARTITION sal95q3 VALUES LESS THAN TO_DATE (01-OCT-1995, DD-MON-YYYY),
14 PARTITION sal95q4 VALUES LESS THAN TO_DATE (01-JAN-1996, DD-MON-YYYY));
(PARTITION sal94q1 VALUES LESS THAN TO_DATE (01-APR-1994, DD-MON-YYYY),
*
ERROR at line 7:
ORA-00906: missing left parenthesis
|
|
|
Re: partition [message #7840 is a reply to message #7833] |
Fri, 11 July 2003 09:28 |
Navtej
Messages: 19 Registered: July 2003
|
Junior Member |
|
|
CREATE TABLE sales
(s_productid NUMBER,
s_saledate DATE,
s_custid NUMBER,
s_totalprice NUMBER)
PARTITION BY RANGE(s_saledate)
(PARTITION sal94q1 VALUES LESS THAN (TO_DATE ('01-APR-1994', 'DD-MON-YYYY')),
PARTITION sal94q2 VALUES LESS THAN (TO_DATE ('01-JUL-1994', 'DD-MON-YYYY')),
PARTITION sal94q3 VALUES LESS THAN (TO_DATE ('01-OCT-1994', 'DD-MON-YYYY')),
PARTITION sal94q4 VALUES LESS THAN (TO_DATE ('01-JAN-1995', 'DD-MON-YYYY')),
PARTITION sal95q1 VALUES LESS THAN (TO_DATE ('01-APR-1995', 'DD-MON-YYYY')),
PARTITION sal95q2 VALUES LESS THAN (TO_DATE ('01-JUL-1995', 'DD-MON-YYYY')),
PARTITION sal95q3 VALUES LESS THAN (TO_DATE ('01-OCT-1995', 'DD-MON-YYYY')),
PARTITION sal95q4 VALUES LESS THAN (TO_DATE ('01-JAN-1996', 'DD-MON-YYYY')));
|
|
|
|