RE: Riddle me this, Batman. Why get an ora-922 when creating a partition?
- From: "Bellows, Bambi (Comsys)" <bbel5@xxxxxxxxxxxx>
- To: "Bill Ferguson" <wbfergus@xxxxxxxxx>, <harel.safra@xxxxxxxxx>
- Date: Wed, 5 May 2010 12:27:17 -0500
Yep, Harel wins the Batman-of-the-Day award!
-----Original Message-----
From: Bill Ferguson [mailto:wbfergus@xxxxxxxxx]
Sent: Wednesday, May 05, 2010 12:20 PM
To: harel.safra@xxxxxxxxx
Cc: Bellows, Bambi (Comsys); oracle-l L
Subject: Re: Riddle me this, Batman. Why get an ora-922 when creating a
partition?
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:
