Re: Partitions to non-partition

  • From: "Darrell Landrum" <darrell@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 12 Aug 2004 19:25:02 -0500

Michael, you don't mention which database version (and it may not matter),
but what you describe is entirely possible.  I've done it on  You
may need to use "ignore=Y" to avoid warnings, but the data can still get
safely from partitioned table to non-partitioned table.

----- Original Message ----- 
From: "Kline.Michael" <Michael.Kline@xxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, August 12, 2004 3:01 PM
Subject: Partitions to non-partition

> I've got data in one database that's not allowed to be touched for now,
> but I would like to get it out and take it to another database where the
> same table is NOT partitioned.

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: