Re: Table Partation Question

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 10 Feb 2004 13:02:07 GMT
Message-ID: <jD4Wb.50723$Wa.48739@news-server.bigpond.net.au>

<rc_at_die@you@!spammers.sandworm.demon.co.uk> wrote in message news:4g5g201ih27do36nab27j3lvhtpq54uc2o_at_4ax.com...
> Hi
>
> I want to partition an un-portioned table. We user oracle 8.1.7.4 on
> Solaris 8
>
> Can I export the data, drop and recreate the table with partition
> ranges and import with ignore=y.
>
> Is there any bugs etc I should be aware of and will this work?
>
> I have not tested it yet, but if any one can give me any advance
> warnings?
>

What you're proposing is a perfectly valid approach.

There are other approaches such as CTAS with subsequent drop/rename, exchange partitions with subsequent splits and renames, etc. but your approach is possibly easiest.

Good Luck

Richard Received on Tue Feb 10 2004 - 07:02:07 CST