Bug: DDL for subpartitioned tables is missing

[BWendling]

Hi,

for subpartioned tables (i.e. range, then list) the complete partition by clause is missing in "Edit table" - View SQL?!

 

[Marco Kalter]

Subpartitions are indeed not yet supported. This is on the list of enhancement requests though.

 

[Sigal]

When table is partitioned and indexes partitioned too (using phrase LOCAL in CREATE INDEX statement) SQLDeveloper can't view correct information about it indexes.
"View SQL" shows incorrect information too.

Sample1: CDR_DETAIL and is't indexes is partitioned. Indexes storaged in tablespace JIC_INDEX_CALL. This info not showed in task "View table", tab "Indexes". And "View SQL" create incorrect text too.

Sample2: CDR_SUMMARY is partitioned, but it's indexes is not partitioned. It's indexes storaged in another tablespace JIC_INDEX_SUM. This info SHOWED in task "View table", tab "Indexes". And "View SQL" shows correct text.

Why it occurs?

 

[Marco Kalter]

Partitioned indexes (like subpartitions) are not yet supported.

 

[Sigal]

In future versions are planned support partitioned indexes?

 

[Marco Kalter]

Yes, see my first reply .