the fine Data Warehousing
manual:
here's an example of range partitioning. Note the to_date in the
values clause. I don't see why you couldn't use
to_date(date_column,'MONTH')
Rachel
CREATE TABLE sales
(s_productid NUMBER,
s_saledate DATE,
s_custid NUMBER
Pardon if this is a duplicate, but the original has not shown up
on the list after 3 hours...
Is it possible in 9.2 to partition on a function?
I have a table with a date column and I would like to partition
by month, regardless of the year. For example, data from January
2003 or January 2004
First time I've seen this post. And from the fine Data Warehousing
manual:
here's an example of range partitioning. Note the to_date in the
values clause. I don't see why you couldn't use
to_date(date_column,'MONTH')
Rachel
CREATE TABLE sales
(s_productid NUMBER,
s_saledate DATE
Dan,
Good question, but unless I'm misinterpreting the results, the answer is
no...
SQL show release
release 902000100
SQL create table test
2 (a date, b number, c number)
3 partition by list (to_char(a, 'MON'))
4 (partition pJAN values ('JAN')),
5
The only way I see is using a system-maintained ( through a before-insert
and if necessary before-update trigger ) field that is set to
to_char(date_column,'mm') and then range partition on that.
At 03:24 PM 1/14/2004, you wrote:
Pardon if this is a duplicate, but the original has not shown up
PROTECTED] On Behalf Of David
WagonerSent: 03 December 2003 14:25To: Multiple
recipients of list ORACLE-LSubject: RE: partitioning option
licensing
As of 9iR2, partitioning is still licensed separately as a
$10K (retail) extra charge per processor. So, the total retail comes to
a painful
Hi,
We're looking into migrating from SQL server to Oracle. Does anyone know if
Partitioning option is still licensed separately?
Thanks.
pat
_
Our best dial-up offer is back. Get MSN Dial-up Internet Service for 6
months
Title: RE: partitioning option licensing
As of 9iR2, partitioning is still licensed separately as a $10K (retail) extra charge per processor. So, the total retail comes to a painful $50K per processor for 9i + Partitioning. Also, remember that support costs X% of the licensing per year
-Original Message-
Hi,
We're looking into migrating from SQL server to Oracle. Does
anyone know if
Partitioning option is still licensed separately?
Thanks.
pat
Having just met with an Oracle rep yesterday. Yes, it is still
licensed separately.
--
Please see the official
]
Subject: RE: partitioning option licensing
As of 9iR2, partitioning is still licensed separately as a $10K (retail)
extra charge per processor. So, the total retail comes to a painful $50K
per processor for 9i + Partitioning. Also, remember that support costs X%
of the licensing per year
-Original Message-
Sent: Thursday, 4 December 2003 01:25
To: Multiple recipients of list ORACLE-L
As of 9iR2, partitioning is still licensed separately as a $10K (retail) extra charge
per processor. So, the total retail comes to a painful $50K per processor for 9i +
Partitioning
most of the oracle docs state that when you partition a table you will get the most
performance benefits by splitting the datafiles for each partition onto seperate
storage devices.
Im on an NAS and all I see are logical mount points. What are your recommendations for
this?
--
Please see
To paraphrase Pythia, an early leader on the DSS market,
my advice would be
Partition not create monolythic.
Partitioning is done for performance reasons, that much is clear.
To really answer your question in any other way then speaking
quixotically on laurel (SQL for short), I'd need to know
At the site of one of my customers, in a not too big (100GB) database
environment, using NAS over NFS on RS/6000 with AIX gave us far from
enough throughput. It turned out that much more mountpoints (20 i.s.o. 2)
were necessary to get a more-or-less satisfactory throughput.
At 10:54 6-11-03
8
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): Partitioned Table
Product Version: 9.2.0.1.0
Table partitioning
Hi,
I've a query reg. space usage in context of partitioned tables.
I've a table with 12 partitions P_1 ... P_12. Until now data
got populated in P_1
RDBMS Version: 9.2.0.1.0
Operating System and Version: Solaris 8
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): Partitioned Table
Product Version: 9.2.0.1.0
Table partitioning
Hi,
I've a query reg. space usage in context of partitioned tables.
I've a table
RDBMS Version: 9.2.0.1.0
Operating System and Version: Solaris 8
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): Partitioned Table Product
Version: 9.2.0.1.0
Table partitioning
Hi,
I've a query reg. space usage in context of partitioned tables.
I've a table
.): Partitioned Table Product Version: 9.2.0.1.0
Table partitioning
Hi,
I've a query reg. space usage in context of partitioned tables.
I've a table with 12 partitions P_1 ... P_12. Until now data
got populated in P_1 upto P_6 and future data will come in P_7 etc.
If i delete some huge amount
Table partitioning
I've a query reg. space usage in context of partitioned tables.
I've a table with 12 partitions P_1 ... P_12. Until now data
got populated in P_1 upto P_6 and future data will come in P_7 etc.
If i delete some huge amount of data from P_1 (after archiving
They are indeed, and their prices are (in the order you list them) in
addition to the EE price:
$20K, $20K, $10K, $10K, $10K.
Mogens
Hemant K Chitale wrote:
oops, I forgot to mention Partitioning pricing.
Partitioning is also listed seperately under Enterprise Edition options.
This is 25
PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mogens Nørgaard
Sent: 26 September 2003 12:05
To: Multiple recipients of list ORACLE-L
Subject: Re: Fwd: RE: RAC for download -- re RAC Pricing and
Partitioning
They are indeed, and their prices are (in the order you list them
oops, I forgot to mention Partitioning pricing.
Partitioning is also listed seperately under Enterprise Edition options.
This is 25% of the EE price.
Thus, EE is US$40K per CPU. RAC is US$60K per CPU [40K + 20K].
Partitioning is US$50K per CPU [40K + 10K] and RAC with Partitioning would
be US
://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Hemant K Chitale
Sent: Thursday, September 25, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Fwd: RE: RAC for download -- re RAC Pricing and Partitioning
oops, I forgot
-
Sent: Tuesday, August 12, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
Dennis
What are you trying to achieve by partitioning? Generally I've seen two
common goals, 1) break a large table into more manageable pieces, 2)
performance tuning, so a query only has to scan a small
Dennis
What are you trying to achieve by partitioning? Generally I've seen two
common goals, 1) break a large table into more manageable pieces, 2)
performance tuning, so a query only has to scan a small partition. Sometimes
the two can be achieved simultaneously, sometimes they are at odds
12:04PM
I have worked with partitioning before but have yet encountered the following
challenge -
The table we are trying to partition is a large table with hundreds of millions of
rows, which is ok. But it does not have a month column, although it has dates. I would
like to partition by month
A little addition to my post:
Of course partitioning downtime will not be that bad if you got spare space
to build partitioned table first, transfer data, then do switchover, then
transfer data changed meanwhile (using triggers, snapshots or even
logminer..).
Note that it is possible to add
Are you saying you want to have twelve partitions, one for each month
of the year (regardless of year)?
--- Meng, Dennis [EMAIL PROTECTED] wrote:
I have worked with partitioning before but have yet encountered the
following challenge -
The table we are trying to partition is a large table
a challenge and we want to keep only 2 years data in
the table and periodically drop partitions to save space.
Dennis
-Original Message-
Sent: Tuesday, August 12, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
Dennis
What are you trying to achieve by partitioning? Generally I've
, 2003 7:04 PM
I have worked with partitioning before but have yet encountered the
following challenge -
The table we are trying to partition is a large table with hundreds of
millions of rows, which is ok. But it does not have a month column, although
it has dates. I would like to partition
Partitioning by range will do just fine!
partition by date_col (
partition jan2000 values less than to_date('02-01-2000', 'mm-dd-')
,partition feb2000 values less than to_date('03-01-2000', 'mm-dd-')
);
Kevin
-Original Message-
Sent: Tuesday, August 12, 2003
I have worked with partitioning before but have yet encountered the following
challenge -
The table we are trying to partition is a large table with hundreds of millions of
rows, which is ok. But it does not have a month column, although it has dates. I would
like to partition by month because
Hi Listers,
Please let me know whether I can convert an
existing heavy table into a partitioned table and how? I need this to improve my
query performance.
Thanks and Best Regards
Munish Bajaj
Blank Bkgrd.gif
of list ORACLE-LSubject: Help
Needed regarding partitioning
Hi Listers,
Please let me know whether I can convert an
existing heavy table into a partitioned table and how? I need this to improve
my query performance.
Thanks and Best Regards
Munish
Bajaj
Jack, Munish
First, verify that you have licensed partitioning. Additional cost item.
Second, learn about EXCHANGE PARTITION. This is a highly useful command that
can be used for a multitude of uses. Create a partitioned table and then
exchange your table into it. Extremely fast since it just
Munish,
innocent question, _why_ do you think partitioning will help query
performance? Have you checked asktom site?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
Read about exchanging partitions in chapter 17 and especially Converting a Partition
View into a Partitioned Table :
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/toc.htm
Even though you may not be using a partitioned view, you can use this technique to
create the
That is the greatest RTFM answer that I've ever seen!
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 25, 2003 9:33 AM
To: Multiple recipients of list ORACLE-L
Read about exchanging partitions in chapter 17 and especially
ECTED]Sent: Wednesday, June 25, 2003 5:54
AMTo: Multiple recipients of list ORACLE-LSubject: Help
Needed regarding partitioning
Hi Listers,
Please let me know whether I can convert an
existing heavy table into a partitioned table and how? I need this to improve
my query performance.
Thank
, verify that you have licensed partitioning. Additional cost item.
Second, learn about EXCHANGE PARTITION. This is a highly useful command that
can be used for a multitude of uses. Create a partitioned table and then
exchange your table into it. Extremely fast since it just involves
dictionary
Title: RE: partitioning
Hi
Jacques,
How do
I exactly implement this.In the before insert trigger what after I generate the
value for the new partition column.How does the
records go into that partition.
Have
you tried this.How is the performance for an insert into a table of 10
Title: RE: partitioning
-Original Message-
From: Basavaraja, Ravindra [mailto:[EMAIL PROTECTED]]
How do I exactly implement this.In the before insert trigger
what after I generate the value for the new partition column.How does the
records go into that partition.
Have you tried
Peter,
I've not had very good luck with hash partitioning either, but range works
damn nicely both from a data insertion/update and query point of view. CBO also
runs very consistently.
Dick Goulet
Reply Separator
Author: Peter Barnett [EMAIL
Hi,
I am wondering if there is any way to achieve horizontal partitioning in Oracle.
Assuming that I have about 8 partitions for a table.When there is INSERT onto this
table I want one record
to be inserted into each partition i.e
1st record goes into partition 1
2nd record goes
read about hash partitioning
-Original Message-
Sent: Wednesday, March 19, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am wondering if there is any way to achieve horizontal partitioning in
Oracle.
Assuming that I have about 8 partitions for a table.When
Title: RE: partitioning
You could accomplish this with a before insert trigger and a partitioning column that contains the value 0 through 7.
e.g.
create trigger
before insert
for each row
begin
select mod (sequence.nextval, 8) into :new.partition_column
from dual ;
end ;
/
Something
way to achieve horizontal partitioning in
Oracle.
Assuming that I have about 8 partitions for a table.When there is INSERT
onto this table I want one record
to be inserted into each partition i.e
1st record goes into partition 1
2nd record goes into partition 2
3rd record goes into partition 3
Title: RE: partitioning
thanks
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]Sent: Wednesday, March 19, 2003
11:52 AMTo: '[EMAIL PROTECTED]'Cc:
'[EMAIL PROTECTED]'Subject: RE:
partitioning
You could accomplish this with a before insert trigger
PM
To: Multiple recipients of list ORACLE-L
???
Babu,
On a slightly different approach, is it possible to update the column to the
format MON, from the present MON? If so, then there is hope. You
could create the partitions like this
PARTITIONING BY RANGE (REPORT_CYCLE_CD)
(
PARTITION
).
Substr function doesn't seem to be permitted in the partitioning syntax and
so am getting errors. Only TO_DATE function seems to be permitted. Since it
is not a date column, I would like to know if there is a way to RANGE
partition the table, instead of HASH partitioning.
Appreciate any suggestions
with VARCHAR2(7). The
data in the column of format MON . I need to partition the table based
on the year , that is, substr(report_cycle_cd, 4,4).
Substr function doesn't seem to be permitted in the partitioning syntax and
so am getting errors. Only TO_DATE function seems to be permitted. Since
to be permitted in the partitioning syntax
and
so am getting errors. Only TO_DATE function seems to be permitted. Since
it
is not a date column, I would like to know if there is a way to RANGE
partition the table, instead of HASH partitioning.
Appreciate any suggestions.
Thanks,
-- Babu
Easy to do if it was 'MON'
Oracle 9i has list partitioning that may work for you.
Regards,
Waleed
-Original Message-
Sent: Thursday, March 13, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
??
Dear List,
I have a table of size approx 10gig, and I need to partition
Is list partitioning available in 8i? Iam on 8.1.7.4.
-- Babu
-Original Message-
Sent: Thursday, March 13, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
???
Easy to do if it was 'MON'
Oracle 9i has list partitioning that may work for you.
Regards,
Waleed
-Original
No
-Original Message-
Sent: Thursday, March 13, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L
???
Is list partitioning available in 8i? Iam on 8.1.7.4.
-- Babu
-Original Message-
Sent: Thursday, March 13, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
???
Easy
Babu,
On a slightly different approach, is it possible to update the column to the
format MON, from the present MON? If so, then there is hope. You
could create the partitions like this
PARTITIONING BY RANGE (REPORT_CYCLE_CD)
(
PARTITION P1998 VALUES LESS THAN ('1999%'),
PARTITION P1999
Title: RE: Partitioning
It's true for 9.2, too. It doesn't make sense to
have different storage parameters for hash partitions.
- Original Message -
From:
Jacques Kilchoer
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, February 26, 2003 6:39
PM
Subject
Team,
Our tables are partitioned by 52 weeks. We would like to know the name of
the partitions that are growing/increasing.
Are there storage parameters for Partitions in Oracle 7, 8i, 9i ?
Where can I find supporting documentation?
Or. Where can I find excellent documentation about partition ?
If you have a table partitioned, can you specify the storage size of each
partition in that tables
I looked at dba_tab_partitions and dba_segments views.
Although the show me storage information, I am unable to create a table
where I can specify the storage size for each partition.
Am I doing
]
e-data.com cc:
Sent by: Subject: Partitioning
Yes you can. Check the storage option of the partition clause.
Something like:
create table (sales_yr varchar2(4),)
partition by range (sales_yr)
(partition p1 values less than ('1996')
tablespace blah_p1
storage (initial 100M next 100M pctincrease 0),
partition p2 values
Thank you very much
Conrad...
-Original Message-
Sent: Wednesday, February 26, 2003 5:31 PM
To: Conrad Meertins; Multiple recipients of list ORACLE-L
YES, here's an example:
create table ate_headers(module_id varchar2(13),
session_number varchar2(16),
Conrad
I've always stored each partition in a separate tablespace. Make each
tablespace LMT with uniform extents. But if you want, you can use the
syntax:
partition by range ( parm1, periodenddate )
(
partition sum_fy_01 values less than ('FY', to_date('01011999','mmdd'))
tablespace
Title: RE: Partitioning
I'll add that for HASH partitions or subpartitions you can only specify TABLESPACE, all other storage parameters are taken from table / partition defaults. At least in 8.1.7.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
YES
Ive been reading the 9iR2 docs on partitioning, along with Tom Kytes
excellent chapter on the subject. It
seems that a Global index or unique, local indexes could be used effectively in
an OLTP system, but both have their caveats.
This is a hybrid system- its part OLTP but is also used
Hello,
We are still struggling with partitioning of star schema fact tables.
As of yet, we haven't been able to test/compare any of the following
scenarios (because we're not yet legal with the partitioning option),
so I am posting in the hope that someone with more partitioning
experience
can.
I would definately try to make the primary partition the one most used in a
where clause... make the access fast as you can.
9.2 has some way better partitioning options than 8i has... we have been
just using those because we are in the process of getting up to speed on
our new 9i upgrade
Bill - Since nobody has replied yet, I'll toss in a couple of ideas. What is
your motivation for partitioning?
Performance? That is what I get from your posting. I think you have good
ideas. I'll provide one more that got us a good performance boost. Some
queries were often comparing
these out.
Oracle licensing enables you to try out all (yes, all, including RAC option)
in development as long as you promise not to deploy in production. It is
perfect for your situation - try out all 9.2 partitioning schemes in
development.
Second, you are under impression that partitioning keys should
Actually, even without the date field, queries will still benefit from the
partition-wise join on the charge_id column. You would see something like this
(partition hash all) in the plan:
SELECT STATEMENT CHOOSE (Cost=178026)
PARTITION HASH ALL 1:4:1
HASH JOIN
PARTITION RANGE
Hello,
We are planning to move to Oracle 9.2 on as-yet-undecided platform
(probably red hat linux on ibm hardware).
We finally pursuaded management to purchase the partitioning
license, and I have some questions on partitioning:
Scenario:
Range-Partition tableA on a service_date field by year
[EMAIL PROTECTED] wrote:
Hello,
We are planning to move to Oracle 9.2 on as-yet-undecided platform
(probably red hat linux on ibm hardware).
We finally pursuaded management to purchase the partitioning
license, and I have some questions on partitioning:
Scenario:
Range-Partition
That was not a good buy. Partitioning comes with Oracle 9, partitioning
option is no longer sold separately.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, November 22, 2002 8:44 AM
To: Multiple recipients of list ORACLE-L
Subject: partitioning
Mladen,
are you sure, partitioning is included with oracle 9?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 22, 2002 11:08 AM
That was not a good buy. Partitioning comes with Oracle 9
Partitioning is still a separately licensed product.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient
of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: partitioning questions
Date: Fri, 22 Nov 2002 08:08:55 -0800
That was not a good buy. Partitioning comes with Oracle 9, partitioning
option is no longer sold separately.
-Original Message-
From: [EMAIL PROTECTED]
[m
Message-
Sent: Friday, November 22, 2002 8:09 AM
To: Multiple recipients of list ORACLE-L
That was not a good buy. Partitioning comes with Oracle 9, partitioning option is no
longer sold separately.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday
We have a table with around 80 million rows. The table has been partitioned
by hash as there is no clear way of partitioning depending on range etc..
The data is very unevenly distributed in these partitions. Some of them even
have 3 times the number of rows as compared to the other partitions
Is there a single column/value that you could do LIST partitioning on
instead of range or hash?
Rick
Rishi.Jain@VerizonWi
Rishi,
The algorithm for has partitioning in Oracle requires you to choose your
partition count as a power of 2 (i.e. 2, 4, 8, 16, 32 partitions, etc) any
other number will be unbalanced as you've seen.
Cheers,
Pete
--
Peter Moore
Systems DBA,
Mid-Range Centre of Expertise,
Global Service
[EMAIL PROTECTED] wrote:
We have a table with around 80 million rows. The table has been partitioned
by hash as there is no clear way of partitioning depending on range etc..
The data is very unevenly distributed in these partitions. Some of them even
have 3 times the number of rows
You can do the same thing in Oracle as you did in Informix. Create range partitions
for 0-9 and use your mod 10 on the key. I believe you will have to add a column in
the table to hold the mod number and make that the partitioning column.
HTH,
John
[EMAIL PROTECTED] 11/19/02 11:38AM
We
Rishi,
In hash partitioning you have to select the number of
partitions equal to the power of 2. i.e. 2,4,8,16 so
on.
Your problem of skewed partition size is well
documented in hash partitioning if you don't choose
correct number of partitions.
Please refer to JLewis Book. He deals with this very
Hello
What are the limitations of partitioning a table in Oracle.
Regards,
Deepa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Can you be more precise.
--- [EMAIL PROTECTED] a écrit :
Hello
What are the limitations of partitioning a
table in Oracle.
Regards,
Deepa
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services
I recommend reading Jonothan Lewis book titled 'Practical Oracle 8i'
There is a chapter on partitioning. I was reading it last night. Very
useful.
Govind
-Original Message-
[mailto:PK_Deepa/VGIL;vguard.satyam.net.in]
Sent: Wednesday, October 30, 2002 3:43 AM
To: Multiple recipients
merging partitions back will be pain in *** .
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 30, 2002 12:43 AM
Hello
What are the limitations of partitioning a table in Oracle.
Regards,
Deepa
--
Please see
of any indexes.
I do though know what my indexes is that
are hit the most and was thinking of partitioning them and or maybe the tables.
Firstly
If I was to partition only the table, Would I have to make any changes to the currently indexes
other than rebuilding them.
Second. Is it possible
Title: Message
Hi
all,
Does anybody know
with what version of Oracle partitioning was included at no extra
cost?
Thanks!
-
Jerry
Title: Message
None
It is an option (Means you pay).
Yechiel AdarMehish
- Original Message -
From:
Cunningham, Gerald
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, May 22, 2002 6:38
PM
Subject: partitioning
Hi
all,
Does anybody know
Absolutely true! Even worse, it is an option on top of Enterprise Edition,
so you can't license Standard Edition and buy the partitioning option.
-Original Message-
Sent: Wednesday, May 22, 2002 12:06 PM
To: Multiple recipients of list ORACLE-L
None
It is an option (Means you pay
Damn!
-Original Message-
Sent: Wednesday, May 22, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L
Absolutely true! Even worse, it is an option on top of Enterprise Edition,
so you can't license Standard Edition and buy the partitioning option.
-Original Message-
Sent
worse, it is an option on top of Enterprise Edition,
so you can't license Standard Edition and buy the partitioning option.
-Original Message-
Sent: Wednesday, May 22, 2002 12:06 PM
To: Multiple recipients of list ORACLE-L
None
It is an option (Means you pay).
Yechiel Adar
Mehish
of Enterprise Edition,
so you can't license Standard Edition and buy the partitioning option.
-Original Message-
Sent: Wednesday, May 22, 2002 12:06 PM
To: Multiple recipients of list ORACLE-L
None
It is an option (Means you pay).
Yechiel Adar
Mehish
- Original Message -
To: Multiple
to partitioning option!
Sure, you don't have all the nice features at your disposal for
administration and maintenance that partitioning provides, but when you look
at the price difference between the two choices, and all you need is simple
and basic partitioning, then partitioning view might work for you
here's one for the partitioning gurus out there
I have an INVOICE table that I want to partition for performance and
purging. The way I want to partition it is to do range partitioning on the
INVOICE_STATE column, then sub-partition some of the partitions by
UPDATE_DATE.
The logic behind
Kevin - This sounds similar to a partitioning issue that I was able to
resolve. My suggestion is to consider partitioning on a concatenated key,
INVOICE_STATE, UPDATE_DATE. You'll have to play with it, the partitions
don't work the way you think they do. As I recall, if you say less than
'AL
Thanks to Dennis, I found that partitioning on a concatenated key solves my
dilema.
For those who are interested, here is my new partitioning clause:
PARTITION BY RANGE (invoice_state, update_date) (
PARTITION inv_active VALUES LESS THAN
('B', TO_DATE('01-jan-', 'DD
', maxvalue),
partition post_X values less than (maxvalue, maxvalue)
There are several drawbacks to using this strategy
though, and I would start by questioning what you
hopes to achieve through partitioning and investigate
whether this notionally correct solution is going to
do what he hopes it would
Hello John
Since all values starting with 'V' are lower then 'W' they will be inserted
into partition p1. (tested it).
I did some tests but could not find a way to do what you want.
Maybe a composite partitioning with 4 hash subpartitions
will get you some results.
Yechiel Adar, Mehish
1 - 100 of 150 matches
Mail list logo