RE: Partition Questions

From: Gait, Christopher <cgait_at_condor.nrl.navy.mil>
Date: Fri, 28 Apr 2000 10:03:22 -0400
Message-Id: <10481.104421@fatcity.com>

If you are in Oracle 8i the ENABLE ROW MOVEMENT statement of the partition clause in the create/alter table statement will allow you to have rows shift between partititions when their partitioning key no longer matches the criterion for their partition. Unfortunately I don't see any listing for this feature in the Oracle 8.0.5 documentation, so I believe it's an 8i enhancement to partitioning (along with hashed sub-partitions, by the way, which are an awesome performance enhancer when designed correctly, i.e. partition range based on date, subpartition based on a field commonly used in queries).

Christopher Gait
Software Technology, Inc.
An Exigent Company

---

"Expedience is the mother of convention."

> > To: "oracle list" <oracle_at_telelists.com>
> > cc: (bcc: Lisa Koivu/GELCO)
> >
> > Subject: Partition Questions
> >
> >
> >
> > Hello,
> >
> > If I have a table partition on time.
> > And I update a row in one partition what will happends
> > with the rows.
> > Move from one partition to an other ?
> >
> > Thanks for your help or advice.
> >
> > Regards
> > h.E
> >
> > =====
> > Place4oracle
> > http://altern.org/place4oracle/place4oracle.html
Received on Fri Apr 28 2000 - 09:03:22 CDT