SAP Knowledge Base Article - Preview

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

Symptom

  • 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:

    KBA 2377139_1.png

  • When the target DBMS is ORACLE Version 11g, there is one single partition displayed in the Partitions tab.
    The Physical Options tab displays:

    KBA 2377139_2.png

  • When the target DBMS is ORACLE Version 12c, the file has been successfully reverse engineered.
    The Physical Options tab displays:

    KBA 2377139_3.png

  • 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
),

...


Read more...

Environment

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

Product

SAP PowerDesigner 16.5 ; SAP PowerDesigner 16.6

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.