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:
- 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."
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.