RE: Partitioning a Table Which Contains a Collection

From: Norwood Bradly A <Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV>
Date: Wed, 26 Apr 2000 12:41:52 -0400
Message-Id: <10479.104207@fatcity.com>

You might find some answers at OTN, Ian.

http://technet.oracle.com/doc/server.815/a67774/migcompa.htm

---

Table 8-4 Partitioning: Features Requiring 8.1.0 or Higher Compatibility Level
Functional Area Features Requiring 8.1.0 or Higher Compatibility Level Partitioning of Tables
 Partitioning of Index-Organized Tables

Partitioning of Tables with LOBs

Partitioning of Object Tables

Partitioning of Tables with User-Defined Types, including Columns with the following Types: object, REF, VARRAY, and nested table

Partitioning of Tables Using Composite Methods and Hash Methods  

Partitioning of Hash Clusters
 Support for Hash Partitioning    

-----Original Message-----
From: Ian MacGregor [mailto:ian_at_SLAC.Stanford.EDU] Sent: Wednesday, April 26, 2000 11:56 AM To: Multiple recipients of list ORACLE-L Subject: Partitioning a Table Which Contains a Collection

Our networking folks have become highly involved in monitoring network performance for the high energy physics community. Part of this project is sending pings to the various labs and Universities worldwide and producing reports of the results. Currently the data is stored in compressed , "*.gz" files, but they want to put the data into Oracle. Their current thinking is to have four years of data on line. Four years worth of data is about 60 GB . This is just the data, i.e, excluding any Oracle overhead.

The person responsible for building the system wants to use a table which includes a collection data type; i.e a nested table. Can such a table be partitioned?

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-- 
Author: Ian MacGregor
  INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Apr 26 2000 - 11:41:52 CDT