Export User Objects: problem with partitioned IOT table

[radik]

Hello,

When I try to create DDL script for partitioned IOT table, I have something like this:

--------------------------
create table SAL_LSOUT
(
PERIOD_YEAR NUMBER(4) not null,
PERIOD_MONTH NUMBER(2) not null,
EMP_ID NUMBER(9) not null,
LIC_SUMMA NUMBER(38,2) not null,
constraint XPKSAL_LSOUT primary key (PERIOD_YEAR, PERIOD_MONTH, EMP_ID)
)
partition by range (PERIOD_YEAR)
(
partition P2004 values less than (2005),
partition P2005 values less than (2006),
partition P2006 values less than (2007)
)
organization index;
--------------------------

Script above has a problems:
- words "organization index" must precedeed of partitions block;
- tablespace clause in partition was lost (originally: partition P2004 values less than (2005) tablespace STAFF2004);
- clause: "compress 2" was lost at all;

And some more: it would be nice to have partition options for indexes too.

Thanks

 

[Marco Kalter]

We'll fix it.