OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » partition date wise

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

partition date wise [message #183827]

Mon, 24 July 2006 01:36

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....

Report message to a moderator

Re: partition date wise [message #183978 is a reply to message #183827]

Mon, 24 July 2006 11:54

joy_division
Messages: 4963
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:25:26 CDT 2024