Database Administration (MOSC)

MOSC Banner

Sub-partition details not shown in get_ddl output

Oracle version 19.12.

Even if partitions / sub-partitions exists and are visible in dba_segments and dba_tab_subpartitions, they are not shown in dbms_metadata.get_ddl output for some of the tables. Composite partitioning is used: interval & list.

Any idea why ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center