Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Importing Table Partition

Importing Table Partition

From: Luis Nobre <lcnobre_at_americel.com.br>
Date: 26 Nov 2001 04:55:56 -0800
Message-ID: <72646b0e.0111260455.244d4866@posting.google.com>


Hi.
Is there a way to import a partition, only, into the table it once belonged to before? I've made the following test:

  1. exported the partition, say, P1;
  2. dropped the partition P1;
  3. imported the partition P1 -> here's the tricky part : oracle returns the error "object already exists" eventhough it imports the rows to a different partition.

I would appreciate any help. Thanks in advance. Received on Mon Nov 26 2001 - 06:55:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US