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
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 so
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 into
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
Title: Message
Hi
all,
Does anybody know
with what version of Oracle partitioning was included at no extra
cost?
Thanks!
-
Jerry
Hello All,
We have an 8.1.7. database and have a partitioned table in it. Table has
about 80 million rows and growing fast. Recent changes have forced us to
think about sub-partitioning it further. Also we have to upgrade the database to
9i shortly.
My question is is there any advantage
IIRC, last week or so the question was raised about whether or not
partitioning is an extra cost option. My reading of the URL below
is that it appears that partitioning is included in 9i Standard.
Plus, now I'm not sure exactly what the differences are between
Standard & Enterprise
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 part
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 odd
ABLESPACE DATA_08
);
Jay
>>> [EMAIL PROTECTED] 08/12/03 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
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 tryin
Sent: Tuesday, August 12, 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
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 Mes
TECTED]>
e-data.com> cc:
Sent by: Subject:
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 les
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 data
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
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
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 there is
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
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
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 Se
[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 nu
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/0
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
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
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
M
!
-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: Wednesday, M
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: Mul
similar 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 wo
Hi,
The system is Oracle 9i on Sun 2.8
1) Which partitioning is better to use HASH or RANGE. Do there is some
overhead for oracle
to calculate the hash number
(hash partitioning) to find the particular partition. We need to
partition 2 tables of
sizes 175G and 162G
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 b
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 yo
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-
I am new to the world of partitioning. 816 on W2K. In a white paper on
metalink "How to Implement Partitioning in Oracle Versions 8 and 8i " it
states that "The RULE-based optimizer does not take the partitioning of
tables and
indexes into account."
My question is - if your
70B7
231FB1619EA59FAD899D31CB6EE42649C03099DFA2F53E8A7F634100A
says:
"
Oracle Database Enterprise Edition can be extended with the following
options:
Oracle Real Application Clusters
Oracle Partitioning
Oracle OLAP
Oracle Data Mining
Oracle Spatial
Oracle Advanced Security
Oracle Label Security
Oracle Diagnostics Pack
Orac
I have a set of three tables that I am having trouble deleting from. The
issues are caused by the size of the tables and the foreign keys. There are
no indexes on B and C due to insertion speed requirements. The last time I
emailed the group about this, partitioning was a popular response. I am
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
exper
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
m
ssage-
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 sc
e size of this table,
purging has been 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
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 ?
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 &l
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 wou
George - Your current indexes are global. I have only used global indexes
with partitioning so far. The case against global indexes on partitioned
tables is probably overstated because whenever you do any partition type
stuff you invalidate your global index and have to rebuild it.
Firstly
[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
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 ORA
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
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
>To: Multiple recipients 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.
>
>
Accelerator Center
[EMAIL PROTECTED]
-Original 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: [EMA
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 ALL
Hi,
Oracle 8.1.7 EE
OS: all
I am trying to implement Partitioning of Tables & Indexes on a database
which has non-partitioned tables & indexes. I am looking for suggestions
& gotchas from people who implemented. Couple of specific questions I
have are
1. Once I create
2.8
1) Which partitioning is better to use HASH or RANGE. Do there is some
overhead for oracle
to calculate the hash number
(hash partitioning) to find the particular partition. We need to
partition 2 tables of
sizes 175G and 162G
2 We have about 10 72G hard drives and
Esteem members of the list.
I hope this new year finds you and your's healthy and prosperous.
I have a question on partitioning and the changing of the values assigned to the
partition during creation.
The tablespace was created with AUTOEXTEND ON next 2 M
EXTENT MANAGEMENT LOCAL UNIFORM
All,
Could of any of you
ladies and gents take a peek at this and give me idea of what the explain
plan is getting at ??
Rows Execution Plan---
---
0 SELECT STATEMENT GOAL:
CHOOSE 0 PARTITION
(CONCATENATED) 0
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 &quo
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
Hi,
Does anyone know the algorithm used in hash partitioning?
>From what I have gathered so far, Oracle will evenly distribute data across
available partitions. Rows are inserted into partitions based on a hash
value of the partitioning key.
Having said that, if I create a hash partitio
Hello all,
Just really a quick one - Does anybody know if partitioning is still a
chargeable option in 9i, or is it now bundled?
Cheers
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing | F: +44 (0)870 127 5283
We are in the process of deciding whether to purchase a license for the
partitioning option of Oracle.
We are developing a data warehouse, with our largest tables being approx 2
million rows and about
300 Megs in size.
We have setup two tables, a standard table ( < 2 million rows) an
You are right. Partitioning can still make your job as a DBA easier.
You can purge data (assuming the purge key is the same as partition key)
by dropping partition, etc.
-Original Message-
Sent: Thursday, March 14, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L
I am new to the
goes south. I prefer to set the database
to
'choose' mode which allows the best of both worlds.
Dick Goulet
Reply Separator
Author: Shaw John-P55297 <[EMAIL PROTECTED]>
Date: 3/14/2002 9:33 AM
I am new to the world of partitioning. 8
I think what my boss is asking me to do is not possible, but since I don't
have much experience with partitioning I thought I'd ask here (I did read
some of manuals but didn't find an answer that suited my conditions). My
boss wants a table partitioned by 2 columns - seq_no and ty
and C.
Sunny
>From: Erik Williams <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Partitioning Tables
>Date: Thu, 15 Nov 2001 11:00:54 -0800
>
>I have a set of three tables that I am having t
tried the USE_NL hint (to prevent the
hash-join) and the INDEX hint, but neither have
worked.
We have
partition_view_enabled = TRUE in the ini file.
Any Suggestions Would be greatly appreciated. (We
can't run Oracle Enterprise Edition
and therefore can not use Oracle Partitioning)
Thanks,
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
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
<>
nce better if I 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 sp
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 compa
ting 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 k
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
lice
-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
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
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
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 (parti
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(,'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
on the list
*
> ERROR at line 7:
> ORA-14120: incompletely specified partition bound for a DATE column
>
> kirti @dbmp : SQL>
>
> If anyone has any tricks to get around this issue, I would love to
> hear.
>
> Cheers!
>
> - Kirti
>
>
>
> --- Rachel Ca
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
algorithm used in hash
> partitioning?
>
> From what I have gathered so far, Oracle will evenly
> distribute data across
> available partitions. Rows are inserted into
> partitions based on a hash
> value of the partitioning key.
>
> Having said that, if I create a hash part
Hi
Is there a white paper on benchmarking done by Oracle on Partitioning?
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sona
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
partitioning option of Oracle.
We are developing a data warehouse, with our largest tables being approx 2
million rows and about
300 Megs in size.
We have setup two tables, a standard table ( < 2 million rows) and a
partitioned table using the data from the
standard table. We used two types of inde
Are you sure your query able to exclude partitions?
Another thing to consider is not only query performance, but table maintenance. It is
much easier to drop a partition than it is to delete x million rows. Partitioning
definitely improves query performance and table maintenance for us (360
FY', to_date('02012001','mmdd'))
tablespace data_fy_04
storage ( maxextents unlimited ),
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, March 15, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
I think wha
I've never done partitioning but I've got an idea. What about adding a
column to hold a value of what partition you want to be in (P1-P6),
then populate that with a pre-insert trigger with whatever logic you
want...?
It's probably a naive idea, but I'm sure I'll learn f
If I understood the original question correctly, with the given conditions
there will be three partitions. Oracle evaluates concatenated key from left
to right order, so if the type and seq number are the partitioning columns
here then the partitions would be:
P1 -- values less than (
al Message-
Sent: Friday, March 15, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
If I understood the original question correctly, with the given conditions
there will be three partitions. Oracle evaluates concatenated key from left
to right order, so if the type and seq number are
stood the original question correctly, with the given conditions
there will be three partitions. Oracle evaluates concatenated key from left
to right order, so if the type and seq number are the partitioning columns
here then the partitions would be:
P1 -- values less than ('X', 99
quently get some fuzzy ideas clarified
by others on the list.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, March 15, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
If I understood the original question correctly, with the given conditions
OTECTED]
-Original Message-
Sent: Friday, March 15, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
I think what my boss is asking me to do is not possible, but since I don't
have much experience with partitioning I thought I'd ask here (I did read
some of manuals but di
g on the list is that I frequently get some fuzzy ideas clarified
by others on the list.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, March 15, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
If I understood the original question correctl
X', 200),
...
partition PX_max values less than ('X', 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
1 - 100 of 153 matches
Mail list logo