Home » RDBMS Server » Server Administration » partition date wise
partition date wise [message #183827] Mon, 24 July 2006 01:36 Go to next message
Messages: 59
Registered: January 2006
Location: delhi
Hi all,

just give me the syntex for 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: partition date wise [message #183978 is a reply to message #183827] Mon, 24 July 2006 11:54 Go to previous message
Messages: 4759
Registered: February 2005
Location: East Coast USA
Senior Member
PARTITION BY RANGE (to_char(your_date,'DD'))
(PARTITION call_records_1 VALUES LESS THAN ('02') tablespace call_records_1,
 PARTITION call_records_2 VALUES LESS THAN ('03') tablespace call_records_2,

[Updated on: Mon, 24 July 2006 11:55]

Report message to a moderator

Previous Topic: Errors upgrading from to
Next Topic: new database creation in novel
Goto Forum:

Current Time: Mon Jul 24 22:07:01 CDT 2017

Total time taken to generate the page: 0.10482 seconds