OraFAQ Forum: Server Administration » interval partitioning

Home » RDBMS Server » Server Administration » interval partitioning (11g r2)

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

interval partitioning [message #481627]

Thu, 04 November 2010 14:07

sfmconsult
Messages: 1
Registered: October 2009
Location: USA

Junior Member

Please show me the DDL used to create a table that is partitioned by day, then rolled up to a month using the interval partitioning technique. Thanks.

Report message to a moderator

Re: interval partitioning [message #481628 is a reply to message #481627]

Thu, 04 November 2010 14:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

is GOOGLE broken for you?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: interval partitioning [message #481629 is a reply to message #481627]

Thu, 04 November 2010 14:11

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

sfmconsult wrote on Thu, 04 November 2010 20:07

Please show me the DDL used to create a table that is partitioned by day, then rolled up to a month using the interval partitioning technique. Thanks.

Not possible in one table.

Regards
Michel

Report message to a moderator

Re: interval partitioning [message #481638 is a reply to message #481627]

Thu, 04 November 2010 15:32

John Watson
Messages: 8938
Registered: January 2010
Location: Global Village

Senior Member

It is all in the docs,

http://www.oracle.com/pls/db112/to_toc?pathname=server.112%2Fe16541%2Ftoc.htm&remark=portal+%28Books%29

look up the sections in chapter 4 titled "Creating Interval-Partitioned Tables" and "Merging Interval PArtitions"

Report message to a moderator

Previous Topic:	Silent Installation of Oracle 10g R2
Next Topic:	Oracle Database Best Practices

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 05:28:08 CDT 2024