Re: Removing table partition

From: Marián Bednár <>
Date: Fri, 20 Mar 2020 16:08:04 +0100
Message-ID: <>

Hi Mike,

try WITH TABLE clause of the exchange_partition_subpart

example also here


pi 20. 3. 2020 o 15:27 Michael D O'Shea/Woodward Informatics Ltd <> napísal(a):

> Chaps, this is an RTFM question I know, but I am also having no luck.
> Scenario: Oracle 18c XE, Win x64, dev. environment, existing list
> partitioned table with many FK's to and from other tables.
> There seems to be no obvious functionality such as, in *pseudo code*, ALTER
> TABLE COALESCE PARTITION FLATTEN or other such DDL to remove existing
> partitions and return to an unpartitioned table. DBMS_REDEFINITION seemed
> like an obvious port of call too, but the functionality I seek doesn't seem
> to be on offer. Am I missing something?
> Mike

Received on Fri Mar 20 2020 - 16:08:04 CET

Original text of this message