Removing table partition

From: Michael D O'Shea/Woodward Informatics Ltd <woodwardinformatics_at_strychnine.co.uk>
Date: Fri, 20 Mar 2020 14:26:53 +0000
Message-Id: <E5B16A62-3507-4C6E-B592-115678E96574_at_strychnine.co.uk>

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

http://www.strychnine.co.uk <http://www.strychnine.co.uk/>

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

Received on Fri Mar 20 2020 - 15:26:53 CET