Home » RDBMS Server » Server Administration » partition date wise
partition date wise [message #183827] Mon, 24 July 2006 01:36 Go to next message
abs_amit
Messages: 59
Registered: January 2006
Location: delhi
Member
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
joy_division
Messages: 4642
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,
etc.
.
.

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

Report message to a moderator

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


Current Time: Wed Dec 07 16:43:46 CST 2016

Total time taken to generate the page: 0.05703 seconds