Hi Mike,
try WITH TABLE clause of the exchange_partition_subpart
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/ALTER-TABLE.html#GUID-552E7373-BF93-477D-9DA3-B2C9386F2877
example also here
https://stackoverflow.com/questions/46277301/how-to-change-partitioned-table-into-non-partitioned-table-in-oracle-along-with
Marian
pi 20. 3. 2020 o 15:27 Michael D O'Shea/Woodward Informatics Ltd <
woodwardinformatics@xxxxxxxxxxxxxxxx> 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
http://www.strychnine.co.uk
