Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Designing Large tables

Re: Designing Large tables

From: Lun Wing San (Oracle) <wslun_at_qrc.org>
Date: 1997/01/30
Message-ID: <32F119D0.3BCF@qrc.org>#1/1

Hitesh Patel wrote:
>
> We are in the process of creating an archive database which consists
> of few tables of sizes ranging from 4 Gb to 16 Gbytes. Do you have
> any suggestions for creating these tables in terms of partitioning the
> tables, spreading across disks, accessing the data, clustering etc.
> Does anyone has this kind of scenario or know of any articles on the
> internet ?
>

  You can try to use partition view to implement it. By using partition views, you will gain several advantages in performance.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841
Received on Thu Jan 30 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US