Re: Oracle 8 Partitioning- Help!

: > Can any1 give my some pointers on using oracle 8's partitioning? The do's
: > and don't s, as well as how to set it up, and does any additional options
: > need to be installed on the server?

DOs:

        It's better if u've got 2 or more processors on ur database server machine and u should enable the parallel server option...

        together with partition table should be partitioned local index to improve the performance...

        if possible... reside different partitions on different tablespaces to make things safer...

        use exchange instead of parallel insert to load data into the partitioned table...