Turn off Partitioning
From: Sallie Cottingham <Sallie.Cottingham_at_cot.tn.gov>
Date: Tue, 17 Aug 2021 15:22:23 +0000
Message-ID: <SA1PR09MB7951B12EC0F63D019C789FA8DEFE9_at_SA1PR09MB7951.namprd09.prod.outlook.com>
Hi,
We have an older database that has 3 partitioned tables. We have found that there is no real need for the tables to be partitioned and plan to change them to non-partitioned. I've done this in our test environment using the partition_options=merge clause on the IMPDP job.
Date: Tue, 17 Aug 2021 15:22:23 +0000
Message-ID: <SA1PR09MB7951B12EC0F63D019C789FA8DEFE9_at_SA1PR09MB7951.namprd09.prod.outlook.com>
Hi,
We have an older database that has 3 partitioned tables. We have found that there is no real need for the tables to be partitioned and plan to change them to non-partitioned. I've done this in our test environment using the partition_options=merge clause on the IMPDP job.
So now I'm trying to figure out how to get the db to realize that there are no longer any partitioned objects so that if there is license review it will not show any partitioning in use. Has anyone encountered this before?
Thanks!
Sallie A. Cottingham, OCP
Database Administrator
Comptroller of the Treasury
Technology Solutions
[A picture containing food Description automatically generated]
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 17 2021 - 17:22:23 CEST
- image/png attachment: image001.png
