Toad World® Forums

Table Partition

I have a Table name Emp that have million of records.

I need to partition the table by three way 1. Range Partition 2. List Partition 3. Has Partition

Plz give solution if table has data then how we partion the table

Verma,

I can help you no problem, but would like to know how did you get the information of such a partitioned table … what brought you to this solution of partitioning method.
After we agree for your real needs, SQL create table statement would not be a too big problem.

Please be aware that following combinations of basic partitioning result into valid composite partitioning strategies, namely:

  • Range-Range

  • Range-List

  • Range-Hash

  • List-List

  • List-Range

  • List-Hash

  • Interval Partitioning

Brg.