Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Partitioned Tables, Oracle on Solaris
Dear Sir,
I appreciate your prudence to a feature without having benched or studied
this in anger.
In doing some version 8050 validation tests, we benched more or less the
same thing that you have done.
Our problem was to prepare a version7 database before migration. We wanted to download a table be it v7 or v8 with views. Export does not permit this so I used a tool that does precisely this.
Table partitioning permits that most of the table if partitioned by date can be loaded before the reorg or migration. Thus the last month of data was the only data needed to be transferred in our migration.
We could download in parallel from a v7 view and pipe this thro to the new db and loading it with SQL*Loader direct path unrecoverable.
Thus the dreaded reorg of the 24GB table that used to take 10 hours was
solved in a matter of minutes.
I realize that one is not supposed to plug other folks wares or wares of any
sort. So it will be brief.
PDQout (Parallel Data Query) from www.oriolecorp.com
Best Regards
Peter
Tom Pall wrote:
> We purchased partitioning, but the database will grow slowly. For the
> next few months no tables will be large enough to justify partitioning.
>
> The database will, however, be 24X7. With this in mind, I am wondering
> if creating tables I know will grow big enough to warrent partitioning
> as single partition tables at the beginning. My rationale is that
> creating a partitioned table from a non-partitioned table (keeping the
> constrains intact) requires exporting the table, dropping the table,
> recreating it as partitioned, then importing the data.
>
> I experimented with partitioned tables on a test box (Oracle on NT).
> The speed with which Oracle split, mergered, moved partitions was
> encouraging. Moving a partition from one tablespace to another was very
> fast.
>
> I am encouraged from my experiments. However a few experiments cannot
> equal a year of maintaining something. If you would share your
> experiences, good and bad, with maintaning partitioned tables, I would
> truly appreciate it.
Received on Wed Jan 20 1999 - 10:29:33 CST