Re: partinioning for the newbie

okay... ill finish now...

1. create table_new w/ partitions
2. use 'ALTER TABLE table_new EXCHANGE PARTITION <partition_name> WITH TABLE table_old WITH VALIDATION
3. drop table_old
4. rename table_new to table_old 'ALTER TABLE table_new RENAME TO table_old'???

Thanks all

On Wed, 24 Nov 2004 13:08:48 -0700, Bryan Wells <bunjibry_at_gmail.com> wrote:
> All...
>
> I have a table in a 9.2.0 test environment that is supposed to be
> partitioned to match that in production. the appropriate tablespaces
> and index_tablespaces have been created, but Im unsure of the proper
> what to proceed. Heres what I think, correct me in anyway:
>
> 1. create table_new w/ partitions
> 2.
>
> --
> Bryan S Wells
> bunjibry_at_gmail.com
>

-- 
Bryan S Wells
bunjibry_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l