Home » SQL & PL/SQL » SQL & PL/SQL » Composite range-range table
Composite range-range table [message #28816] Fri, 23 January 2004 03:41 Go to next message
Ken Jones
Messages: 70
Registered: January 2004
Member
Guys,

Is it possible to set up a table to be partitioned by YEAR and then subpartitioned by MONTH? The table has 2 columns called FINANCIAL_YEAR and FINANCIAL_MONTH.

I know that we can have composite range-hash partitioned tables.

Please help,

Ken
Re: Composite range-range table [message #28832 is a reply to message #28816] Sun, 25 January 2004 23:29 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Hi,

No, you cannot. The only partitioning methods available are:

- Range partitioning;
- Hash partitioning;
- List partitioning;
- Composite range-hash partitioning; and
- Composite range-list partitioning.

Consider creating range YYYYMM partitions instead. For example: 200311, 200312, 200401, etc.

Best regards.

Frank
Re: Composite range-range table [message #403761 is a reply to message #28832] Mon, 18 May 2009 09:33 Go to previous messageGo to next message
wakula
Messages: 150
Registered: February 2008
Location: Poland
Senior Member
Hi,
Since I'm a nasty guy I want to mark that there is ISO-8601 standart for dates. It says that you should avoid naming the partitions like 200809 because it can be read as 20-Aug-2009 or 2020-Aug-09 or 2008-Sep or something else.
Julian day number is difficult to read on the other hand.
Thus I suggest something like 2008_09 instead.
Re: Composite range-range table [message #403764 is a reply to message #28816] Mon, 18 May 2009 09:42 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
If you are in 11g you can.

http://download.oracle.com/docs/cd/B28359_01/server.111/b28279/chapter1.htm#FEATURENO07190

This is one of the reason why we always advise to post the full oracle version when posting any questions.

Regards

Raj
Re: Composite range-range table [message #403768 is a reply to message #403764] Mon, 18 May 2009 09:49 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
On the other hand, I think 11g was not in really widespread use on "Mon, 26 January 2004", when Frank answered the question. Very Happy
Re: Composite range-range table [message #403783 is a reply to message #403768] Mon, 18 May 2009 11:12 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Oops to be honest with you I didn't see the original poster question date. Embarassed

Well by that time I really doubt whether 11g was in development

Regards

Raj
Previous Topic: Stored Procedure too slow
Next Topic: ORA-00932: inconsistent datatypes: expected - got CLOB
Goto Forum:
  


Current Time: Sun Dec 04 23:04:25 CST 2016

Total time taken to generate the page: 0.05947 seconds