Re: Riddle me this, Batman. Why get an ora-922 when creating a partition?
- From: Maxim Demenko <mdemenko@xxxxxxxxx>
- To: bbel5@xxxxxxxxxxxx
- Date: Wed, 05 May 2010 19:17:48 +0200
Well, the syntax should be probably corrected...
SQL> select * from v$version
2 ;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
SQL> CREATE TABLE JUNK1
2 (
3 column_info_int number NOT NULL,
4 column_info_date date NOT NULL
5 )
6 PARTITION BY RANGE (column_info_date)
7 PARTITION cid20thcentury VALUES LESS THAN (TO_DATE('2000-01-01',
'YYYY-MM-DD'))
8 ;
PARTITION cid20thcentury VALUES LESS THAN (TO_DATE('2000-01-01',
'YYYY-MM-DD'))
*
ERROR at line 7:
ORA-00922: missing or invalid option
SQL>
SQL> CREATE TABLE JUNK1
2 (
3 column_info_int number NOT NULL,
4 column_info_date date NOT NULL
5 )
6 PARTITION BY RANGE (column_info_date)
7 (
8 PARTITION cid20thcentury VALUES LESS THAN (TO_DATE('2000-01-01',
'YYYY-MM-DD'))
9 )
10 ;
Table created.
Best regards
Maxim
On 05.05.2010 19:04, Bellows, Bambi (Comsys) wrote:
SQL> CREATE TABLE JUNK1
2 (
3 column_info_int number NOT NULL,
4 column_info_date date NOT NULL
5 )
6 PARTITION BY RANGE (column_info_date)
7* PARTITION cid20thcentury VALUES LESS THAN (TO_DATE('2000-01-01',
'YYYY-MM-DD'))
Other related posts:
