Re: Data Pump: Importing partitioned objects into target DB w/o partitioning

From: Uwe Küchler <>
Date: Mon, 8 Jun 2009 16:24:29 +0200 (CEST)
Message-ID: <>

Hi Martin,

I took a glance at your nice solution - so your opinion is, that there's no way to solve this problem with data pump only? Looks like I'll have to file an enhancement request with Oracle, then.

Just to make the issue clearer (still hoping someone will pop up with a straightforward solution):

  • Production system runs on partitioned tables.
  • Test system runs with already unpartitioned tables and no partitioning option available.
  • Data Pump _Import_ halts when encountering a partitioned object and no partitioning option is available.
  • This renders the Dump File more or less unusable on any system without the partioning option.

Best regards to Bavaria,

BTW, you might want to visit my (German) Oracle-Blog

On Mo, 8.06.2009, 12:16, Martin Klier wrote:

> Hi Uwe,
> Uwe Küchler schrieb:
>> I have the following issue when trying to import partitioned tables
>> from a source DB to a target DB without the partitioning option.
> maybe you want to have a look at this, it's no straight solution, but
> one that worked for my case:
> Reagrds
> Martin Klier
Received on Mon Jun 08 2009 - 09:24:29 CDT

Original text of this message