Re: Riddle me this, Batman. Why get an ora-922 when creating a partition?
- From: Bill Ferguson <wbfergus@xxxxxxxxx>
- To: harel.safra@xxxxxxxxx
- Date: Wed, 5 May 2010 11:20:13 -0600
Yep, Harel found the problem.
I ran your original script with the same error (on 11.1.0.7, 32-bit on
Windows). After Harel's reply, I added the extra parens and it worked.
CREATE TABLE JUNK1
(
column_info_int number NOT NULL,
column_info_date date NOT NULL
)
PARTITION BY RANGE (column_info_date)
(PARTITION cid20thcentury VALUES LESS THAN (TO_DATE('2000-01-01',
'YYYY-MM-DD')))
--
-- Bill Ferguson
--
//www.freelists.org/webpage/oracle-l
Other related posts:
