Missed syntax of create partitioned table table using Oracle 11.2

[sky_lt]

Hi,

My statement:
CREATE TABLE "XXX"
("X" NUMBER(20,0),
"DATE_" DATE)
PARTITION BY RANGE ("DATE_") INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
(PARTITION "PART_MAIN" VALUES LESS THAN (TO_DATE(' 1900-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')))
ENABLE ROW MOVEMENT;

Statement i got from object browser table => edit then SQL
-- Create table
create table DR_TRANSMASTER.XXX
(
x NUMBER(20),
date_ DATE
)
partition by range (DATE_)
(
partition PART_MAIN values less than (TO_DATE(' 1900-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace DATA_TBS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 80K
next 1M
minextents 1
maxextents unlimited
)
);

Statement through dbms_metadata:
CREATE TABLE "XXX"
("X" NUMBER(20,0),
"DATE_" DATE)
PARTITION BY RANGE ("DATE_") INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
(PARTITION "PART_MAIN" VALUES LESS THAN (TO_DATE(' 1900-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')))
ENABLE ROW MOVEMENT;

Is seems PL/SQL developer misses new partition option INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))

also it misses non default parameter ENABLE ROW MOVEMENT

Sky_lt

 

[Marco Kalter]

Support for the interval partition option for retrieved DDL was added in 9.0.2.

I have added the support for the row movement option to the list of enhancement requests.

 

[sky_lt]

i am using PL/SQL developer Version 9.0.4.1644 and facing this issue

 

[Marco Kalter]

Which of the 2 issues do you mean?

 

[sky_lt]

The first issue:

PL/SQL developer misses new partition option INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))

 

[Marco Kalter]

Okay, we'll check it out.

 

[Bernhard S]

It's high time for PL/SQL Developer to become aware of row movement too. This feature was introduced already with Oracle 8.1.5 (http://docs.oracle.com/cd/F49540_01/DOC/server.815/a67779/ch4g.htm#64909) which came out in 1999, celebrating 13th anniversary this year!

 

[yonderboi]

The problem still exists, "enable row movement" option is not supported neither in table definition editor nor in ddl generator