I am splitting the region_east partition into region_east_1 & region_east_2 as below. My question is, which values('CT', 'VA', 'MD') goes to region_east_1 and which values goes to region_east_2 partition. How oracle maps these values('CT', 'VA', 'MD') to two partitions(region_east_1 & region_east_2). Can any one please clarify?
My questions is...where does the (3) as in At (3) above come from?
I would have thought it comes from the HIGH_VALUE column of the table to be split?
but my does not return anything..
SQL> select high_value from user_tab_partitions where table_name ='AAS_AON_FCT_2004_Q4';
no rows selected
04-02-2007, 01:26 PM
ndisang -- Your example looks like related to range-partitioning where you are creating partitions depending on some value range of the key.
The number (3) in the example is the higher-value you admit in that specific partition
04-02-2007, 10:18 PM
PAVB, thank you for the answer.
04-03-2007, 12:47 PM
You are right PAVB...my table is range partition on date field.
04-21-2007, 01:23 PM
I have one quick question about split partition.
My table is list partitioned table. I have default partition name called REST. Now i wanted to add new partitions, but due to the default partition, i am not able to add it. But default partition REST does not have any values. I mean, default partition is empty now. At this circumstances, i want to add a partition. As per my knowlege, the only option is, drop the default partition and add new partitions. Is there any other options to add new partition at this situation? If so, can any one provide a syntax to add new partition?
04-21-2007, 02:45 PM
You can't add partitions in the middle of your partition set... you have to split partitions.
04-21-2007, 03:47 PM
Dear PAVB, I understand that i can not add a partition now. Can you please tell me the syntax for spliting the default partition. Again, default partition is empty. Now how can i split it? If possible, i need commands for this?