Re: Removing table partition

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_at_strychnine.co.uk> 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
>
>
>

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