Table partitioning
Hi
I am trying to partition a table for performance improvement. I have used 742243 as a reference which is described below.
I have followed the proceedure and created the partitions. But that is not visible in oracle. Could anyone let me know how to approach the problem.
Many thanks for you help
Deb Sircar
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.
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:
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
Master Language: German
Priority: Recommendations/additional info
Category: Installation information
Primary Component: BC-DB-ORA Oracle