Re: A partition to a table

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Thu, 6 Jun 2002 05:39:58 -0500
Message-ID: <ufuf00pebssh78@corp.supernews.com>

You can use the 'exchange partition' command to switch a partition with a table.

alter table my_part_table
exchange partition part_2002 with my_table with validation;

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"ronald" <ronald_at_foo.com> wrote in message news:adnd9v$moo1$1_at_ID-87429.news.dfncis.de...
>
> A can substitute partition for a table (that is, add new data to a
> partitioned table), but can I turn a partition of a partitioned
> table into a separate table?
>
>
>
>
>
>
Received on Thu Jun 06 2002 - 05:39:58 CDT