2377139 - Missing partitions on Oracle tables and indexes after reverse - SAP PD | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

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