RE: Removing table partition

From: Jeff Smith <jeff.d.smith_at_oracle.com>
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 <woodwardinformatics_at_strychnine.co.uk> Sent: Friday, March 20, 2020 10:27 AM
To: oracle-l-freelists <oracle-l_at_freelists.org> 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

HYPERLINK "https://urldefense.com/v3/__http:/www.strychnine.co.uk__;!!GqivPVa7Brio!MlyjbYtYDIDGlE2L2K2fddO8GAAogZYl2qJ86HmfK8_VALw3UKwyHsBEbd3E4ilqaFk$"http://www.strychnine.co.uk

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

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

This message: [ Message body ]
Next message: Ankit Thakwani: "Re: MySQL auditing and tracing options"
Previous message: Khan, Muhammad: "RE: [EXTERNAL] MySQL auditing and tracing options"
In reply to: Michael D O'Shea/Woodward Informatics Ltd: "Removing table partition"
Next in thread: Michael D O'Shea/Woodward Informatics Ltd: "AW: Removing table partition"
Reply: Michael D O'Shea/Woodward Informatics Ltd: "AW: Removing table partition"
Reply: Marián Bednár: "Re: Removing table partition"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message