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
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: Riddle me this, Batman. Why get an ora-922 when creating a partition?
From: Bellows, Bambi (Comsys)

References:
- FRA
  - From: Michael Dinh
- Riddle me this, Batman. Why get an ora-922 when creating a partition?
  - From: Bellows, Bambi (Comsys)
- Re: Riddle me this, Batman. Why get an ora-922 when creating a partition?
  - From: Harel Safra

Re: Riddle me this, Batman. Why get an ora-922 when creating a partition?

Other related posts: