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


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