2377139 - Missing partitions on Oracle tables and indexes after reverse - SAP PD

• When reversing an Oracle database/script, the partition info of Oracle tables and indexes may be missing.
• When the target DBMS is ORACLE Version 10g, there is one single partition displayed in the Partitions tab, and the Physical Options tab displays:
  
  
  
  
• When the target DBMS is ORACLE Version 11g, there is one single partition displayed in the Partitions tab.
  The Physical Options tab displays:
  
  
  
  
• When the target DBMS is ORACLE Version 12c, the file has been successfully reverse engineered.
  The Physical Options tab displays:
  
  
  
  
• Partitions define the LOB storage clause and use the BASIC keyword for the COMPRESS clause.
• Example of a partitioned table with LOBs (see attachment):

create table T1 ( C1 number )
LOB (PBUFFER) STORE AS (
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
)

partition by range (PART) (
partition p1 values less than (to_date('01/01/2016','mm/dd/yyyy'))
COMPRESS BASIC
LOB (PBUFFER) STORE AS (
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
),

...

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SAP PowerDesigner (PD) 16.5 SP05
• SAP PowerDesigner (PD) 16.6 SP01
• Oracle DBMS

RE, engineering, 802755, CR802755, CR#802755 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed