Tuesday, April 22, 2008

SAP Note :742243-General Table Partitioning as of SAP Basis 46C

29.03.2007 Page 1 of 3
SAP Note Number 742243 - General table partitioning as of
SAP_BASIS 46C
Note Language: English Version: 3 Validity: Valid from 03.06.2004
Summary
Symptom
In addition to the limited options for partitioning tables that are alre
ady available, you can now partition tables with all methods available in
Oracle. Subpartitioning however, is not supported.
Other than the tables that were created and partitioned with database
utilities, tables that were partitioned in this way also remain partitionen
after a conversion.
In SAP_BASIS 46x, the partitioning of a table is not retained during a
homogeneous migration, for SAP_BASIS 620, we are working on a solution that
will enable you to retain the feature.
More Terms
Cause and Prerequisites
The additional partitioning options are released with Support Package 48
for Release 46C and Support Package 37 for Release 46D.
Solution
Using the database utility (transaction SE14), you can partition a table
defined in the DDIC with the RANGE, LIST or HASH methods.
Since the use of transaction SE14 is not obvious, we will explain the
partitioning of a table with an example.
Enter the table to be partitioned in transaction SE14, choose "Edit" and
choose the "Storage parameter" pushbutton in the subsequent screen.
In the next menu, choose the "For new creation" pushbutton.
Place the cursor on "Table" and choose "Create parameter values" (second
button) in the application toolbar.
You can select a template for the parameter values, for example, "Current
Database Parameters".
The subsequent screen is similar to the following:
INDEX ORGANIZED
TABLESPACE
INITIAL EXTENT 16
NEXT EXTENT 160
MINIMUM EXTENTS 1
MAXIMUM EXTENTS 300
PCT INCREASE 0
FREELISTS 1
FREELIST GROUPS 1
PCT FREE 10
PCT USED 40
PARTITION BY
You can select the partitioning method in the "PARTITION BY" parameter with
the input help.
29.03.2007 Page 2 of 3
SAP Note Number 742243 - General table partitioning as of
SAP_BASIS 46C
Depending on the type you select, more parameters will be displayed, for
example, the "COLUMN LIST" parameter for RANGE, and "HIGH VALUE" for the
displayed partition.
INDEX ORGANIZED
TABLESPACE
INITIAL EXTENT 16
NEXT EXTENT 160
MINIMUM EXTENTS 1
MAXIMUM EXTENTS 300
PCT INCREASE 0
FREELISTS 1
FREELIST GROUPS 1
PCT FREE 10
PCT USED 40
PARTITION BY RANGE
COLUMN LIST
PARTITION
PARTITION NAME
HIGH VALUE
TABLESPACE
INITIAL EXTENT
.....
For each parameter, you can enter one or multiple values. The values are
case-sensitive and must be entered depending on the data type (if
necessary, enclose them in single quotes (')).
To obtain another entry for a parameter, for example, for PARTITION or HIGH
VALUE, you must place the cursor on the parameter and choose "Insert
parameter values" (fourth button) in the application toolbar.
.......
PCT FREE 10
PCT USED 40
PARTITION BY RANGE
COLUMN LIST
PARTITION
PARTITION NAME
HIGH VALUE
HIGH VALUE
TABLESPACE
INITIAL EXTENT
PARTITION
PARTITION NAME
HIGH VALUE
HIGH VALUE
TABLESPACE
INITIAL EXTENT
.......
If you enter several values for a parameter, the entries must follow the
right syntax; for example, if you want to enter three field names in the
"COLUMN LIST" parameter, the entry must look as follows:
29.03.2007 Page 3 of 3
SAP Note Number 742243 - General table partitioning as of
SAP_BASIS 46C
COLUMN LIST "COL1", "COL2", "COL3"
After you have populated and saved the parameter values, you can create the
required table with transaction SE14 in the database by choosing the
"Activate and adjust database" pushbutton.
Partitioning of an index is only supported in line with the partitioning of
the table (local index). You can specify this option by populating the
"PARTITIONED" parameter:
PARTITIONED X
Header Data
Release Status: Released for Customer
Released on: 03.06.2004 15:01:27
Priority: Recommendations/additional info
Category: Installation information
Main Component BC-DB-ORA Oracle
Valid Releases
Software Component Release From
Release
To Release and Later
SAP_BASIS 46C 46C 46D
SAP_BASIS 60 620 640
Support Packages
Support Packages Release Package Name
SAP_BASIS 46C SAPKB46C48
SAP_BASIS 46D SAPKB46D37
SAP_BASIS 620 SAPKB62042
SAP_BASIS 620 SAPKB62045
SAP_BASIS 640 SAPKB64005
SAP_BASIS 640 SAPKB64010
Related Notes
Number Short Text
919840 Performance at the creating/maintaining demand history
722188 FAQ: Oracle partitioning
565725 Optimizing the performance of ODS objects in BW 3.0B
105047 Support for Oracle functions in the SAP environment

No comments:

Latest Gadget

Search