RE: Partitioning a Table Which Contains a Collection

Hi Ian,

I think you can partition the parent, but not the nested table segment.

I don't think nested tables are intended for large volumes of data. The only access path that Oracle has on the nested table segment is a full table scan, unless you build an index on a hidden column
(the nested_table_id).

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/


-----Original Message-----
From:	Ian MacGregor [SMTP:ian_at_SLAC.Stanford.EDU]
Sent:	Thursday, April 27, 2000 2: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).