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 -- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- //www.freelists.org/webpage/oracle-l