Home » SQL & PL/SQL » SQL & PL/SQL » how can create dynamic partitioned table
how can create dynamic partitioned table [message #183844] Mon, 24 July 2006 02:26 Go to next message
Messages: 59
Registered: January 2006
Location: delhi
Hi all,

is it possible that if a record doestn't get sufficiant range partition in the table then automatically a partition should be created for that record.

like if date is inserted 31-Jul-2006 and partion is not there so partion should created automatically....

if this is not possible then plz let me know how can do the following

creating a partition table
date wise
i.e. I have a table having 6months records.

i want to make 31 partition---> 1st to 31st
records should go to datewise partition like

1st march's records in partition call_records_1
1st april's '' '' '' call_records_1

2nd feb's '' " " call_record_2

should be independant of month..... only date wise .....

Thanks in advance....
Re: how can create dynamic partitioned table [message #183850 is a reply to message #183844] Mon, 24 July 2006 02:43 Go to previous message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You cannot create a table that partitions on the DAY OF MONTH (ie. 1 to 31).

How did you think this would help anyway? Do you have lots of SQLs with:

If you are not looking at "useful" partitions, and just want to bust the table up into 31 chunks of roughly even size, you can try HASH partitioning. It won't help with the above type of SQL, but it can be helpful with EQUALS and IN-list conditions, and with joining to identically partitioned tables.

It should be noted that this is a pretty silly sort of partitioning scheme. I would go back to RANGE partitioning if I were you. It's ever so much more practical.

Ross Leishman
Next Topic: how to encrypt and store the password?
Goto Forum:

Current Time: Mon Jul 24 20:04:42 CDT 2017

Total time taken to generate the page: 0.96065 seconds