FAQ
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

Search Discussions

  • Norwood Bradly A at Apr 26, 2000 at 4:41 pm
    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
    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).
  • Steve Adams at Apr 28, 2000 at 2:07 am
    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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedApr 26, '00 at 2:49p
activeApr 28, '00 at 2:07a
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase