Thanks Jeff ... I would of course have to drop existing constraints and
indexes, then recreate them all afterwards too.
Guess I have to fess up as well, it isn't one table, but around 400, albeit
quite small (ranging from a few dozen to a few million rows). I will likely
script it all as a last resort. I am just a little aghast that implementing
partitions on existing tables appears to be natively supported whereas going
the other way ... you cannot, it's a one way road.
Mike
http://www.strychnine.co.uk ;<http://www.strychnine.co.uk/>
Am 20.03.2020 um 14:45 schrieb Jeff Smith <jeff.d.smith@xxxxxxxxxx>:
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
<woodwardinformatics@xxxxxxxxxxxxxxxx
<mailto:woodwardinformatics@xxxxxxxxxxxxxxxx>>
Sent: Friday, March 20, 2020 10:27 AM
To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx
<mailto:oracle-l@xxxxxxxxxxxxx>>
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?
Mike
http://www.strychnine.co.uk ;
<https://urldefense.com/v3/__http:/www.strychnine.co.uk__;!!GqivPVa7Brio!MlyjbYtYDIDGlE2L2K2fddO8GAAogZYl2qJ86HmfK8_VALw3UKwyHsBEbd3E4ilqaFk$>
