Re: partinioning for the newbie
- From: Bryan Wells <bunjibry@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Nov 2004 13:14:36 -0700
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@xxxxxxxxx> 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@xxxxxxxxx
>
--
Bryan S Wells
bunjibry@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
