Re: Partitioning Question

From: Jan Nowitzky <nowitzky_at_informatik.uni-jena.de>
Date: Mon, 25 Oct 1999 09:59:58 +0200
Message-ID: <38140DFE.571BF7A0@informatik.uni-jena.de>

yes, Oracle will insert the rows according to the partitioning ranges into each partition. The partition criteria works like a function; the tupel (rows) is the input and the function pass back the partition. If you want insert mass data into only one partition, you can help Oracle by specifying the partition.

If you move all rows of your stage table into one partition of the fact table, may be you can use the 'alter table ... exchange' statement; its really fast.

Jan

usmrall wrote:
>
> Hello all,
> The way I understand partitioning is that data is stored in logically
> (and physicially if different partitions are on diff disks) in separate
> areas. How will Oracle treat an insert into a partitioned table ?
> will it look at teh values and determine in which partition to place the
> data ? I load data into a stage table and then move it into the DW
> fact table, which is partitioned on year and period.
> tia,
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--

---

Jan Nowitzky
Friedrich-Schiller-Universität o Institut für Informatik E-Mail nowitzky_at_informatik.uni-jena.de

---

Received on Mon Oct 25 1999 - 02:59:58 CDT