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 Received on Wed Apr 26 2000 - 09:49:53 CDT