RE: Removing table partition

From: Jeff Smith <>
Date: Fri, 20 Mar 2020 07:45:06 -0700 (PDT)
Message-ID: <78b4436e-05fb-4e4f-bde5-7903f415a039_at_default>

CTAS would nuke the partitions.since you're say 'XE', I'm assuming you don't have THAT much data.  

From: Michael D O'Shea/Woodward Informatics Ltd <> Sent: Friday, March 20, 2020 10:27 AM
To: oracle-l-freelists <> Subject: Removing table partition  

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?  


HYPERLINK ";!!GqivPVa7Brio!MlyjbYtYDIDGlE2L2K2fddO8GAAogZYl2qJ86HmfK8_VALw3UKwyHsBEbd3E4ilqaFk$"    

Received on Fri Mar 20 2020 - 15:45:06 CET

Original text of this message