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

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,
Uwe

--
BTW, you might want to visit my (German) Oracle-Blog
http://oraculix.wordpress.com/


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:

>

> http://www.usn-it.de/index.php/2009/03/30/oracle-convert-a-partitioned-table-into-an-unpartitioned-one/

>

> Reagrds

> Martin Klier



--
http://www.freelists.org/webpage/oracle-l