Skip to Content
0
Former Member
Jan 27, 2009 at 05:22 AM

Table partitioning

494 Views

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