Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!canoe.uoregon.edu!csulb.edu!tethys.csu.net!nntp!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: "Steve Ashmore" <sashmore@neonramp.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: A partition to a table
Date: Thu, 6 Jun 2002 05:39:58 -0500
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <ufuf00pebssh78@corp.supernews.com>
References: <adnd9v$moo1$1@ID-87429.news.dfncis.de>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Complaints-To: newsabuse@supernews.com
Lines: 27
Xref: easynews comp.databases.oracle.server:149726
X-Received-Date: Thu, 06 Jun 2002 04:46:27 MST (news.easynews.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@foo.com> wrote in message
news:adnd9v$moo1$1@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?
>
>
>
>
>
>