RE: Turn off Partitioning

Thank you Leng. I think the cleanest was will be to create a new db. I wouldn’t want the usage history to still be there and in question if we had a review.

Thanks,

Sallie A. Cottingham, OCP
Database Administrator
Comptroller of the Treasury
Technology Solutions
425 Rep. John Lewis Way N. | Nashville, TN 37243 sallie.cottingham_at_cot.tn.gov<mailto:sallie.cottingham_at_cot.tn.gov> | Direct Line 615.401.7962

[A picture containing food Description automatically generated]

From: Leng Burgess <lkaing_at_gmail.com> Sent: Tuesday, August 17, 2021 10:19 PM To: Sallie Cottingham <Sallie.Cottingham_at_cot.tn.gov> Cc: ORACLE-L <oracle-l_at_freelists.org> Subject: Re: Turn off Partitioning

Hi Sallie,

I don’t know how to turn off partitioning from the binaries themselves - I think chopt may do this.

With many oracle features, I believe the story is that even if it’s installed, you won’t be charged if you don’t use. The usage history can be viewed in dba_features_usage_statistics If you need to clear that history altogether I believe you’ll need to create a new db and import from scratch.

Cheers,

Leng.

On 18 Aug 2021, at 1:22 am, Sallie Cottingham <Sallie.Cottingham_at_cot.tn.gov<mailto:Sallie.Cottingham_at_cot.tn.gov>> wrote:

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
425 Rep. John Lewis Way N. | Nashville, TN 37243 sallie.cottingham_at_cot.tn.gov<mailto:sallie.cottingham_at_cot.tn.gov> | Direct Line 615.401.7962

<image001.png>

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




image/png attachment: image001.png