Home » RDBMS Server » Server Administration » interval partitioning (11g r2)
interval partitioning [message #481627] Thu, 04 November 2010 14:07 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous message
John Watson
Messages: 8960
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 08:36:37 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.