All Forums Database
karan_19111986 3 posts Joined 02/14
07 Feb 2014
Specifying partition names for a PPI

Hello ,
I have a n00b question, I wanted to know whether its possible to specify names for the individual partitions that we create in the CREATE TABLE statement.
For example, is something like this possible (?) :
 

 

CREATE TABLE DATABASENAME.SALES_DETAIL 

(.....)

PRIMARY INDEX SALES_DETAIL ( CUST_ORD_ID )

PARTITION BY RANGE_N

(

BUSINESSDAY_DT BETWEEN

PART_1 2007011 AND 2007527 EACH 1 ,

PART_2 2008011 AND 2008527 EACH 1 ,

PART_3 2009011 AND 2009527 EACH 1 ,

PART_4 2010011 AND 2010527 EACH 1 ,

NO RANGE
)
;

 

Or is there some other syntax to implement the same?  That is, naming the individual partitions ?
Regards,
Karan

Adeel Chaudhry 773 posts Joined 04/08
07 Feb 2014

I dont think its possible, why would you want to have this?

-- If you are stuck at something .... consider it an opportunity to think anew.

sgarlapa 88 posts Joined 03/13
07 Feb 2014

No. this option don't exist.

You must sign in to leave a comment.