| list partitioning error [message #175684] |
Sun, 04 June 2006 16:21  |
ziyati
Messages: 4
Registered: June 2006
Location: morocco
|
Junior Member |
|
|
Hi
i have a probelem with list partitioning using oracle 9i, i can not resolve it,when i wrote :
CREATE TABLE sales_list
(salesman_id NUMBER(5),
salesman_name VARCHAR2(30),
sales_state VARCHAR2(20),
sales_amount NUMBER(10),
sales_date DATE)
PARTITION BY LIST(sales_state)
(
PARTITION sales_west VALUES('California', 'Hawaii'),
PARTITION sales_east VALUES ('New York', 'Virginia', 'Florida'),
PARTITION sales_central VALUES('Texas', 'Illinois')
PARTITION sales_other VALUES(DEFAULT)
);
it give me a error
VALUES(DEFAULT)
*
statement missing
what wrong here ? please ineed help
thanks in advance
|
|
|
|
| Re: list partitioning error [message #175723 is a reply to message #175684] |
Mon, 05 June 2006 02:41  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
I hope by now, you must have solved the issue, as all you are missing in this statement is a comma ",".
PARTITION sales_central VALUES('Texas', 'Illinois')
PARTITION sales_other VALUES(DEFAULT)
--Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
