Re: Obj$ table

From: Jonathan Lewis <>
Date: Tue, 31 Mar 2020 12:33:11 +0000
Message-ID: <LNXP265MB1562D0FC0B55B77D6396985EA5C80_at_LNXP265MB1562.GBRP265.PROD.OUTLOOK.COM>

00701, 00000, "object necessary for warmstarting database cannot be altered"

I think this is a message you get for any object above the "//" point in what is now dcore.bsq, though things have changed a lot for pluggable databases and there are also "pseudo-bootstrap" objects that might also trigger the same error.

Jonathan Lewis

From: <> on behalf of Lothar Flatz <> Sent: 31 March 2020 09:08
Subject: Re: Obj$ table

Changing the structure is prevented. Error message should be something like "you don't want to tamper with the boot strap."  Defragment I don't know. It would depend on the command. I would think of "alter table move".

Am 31.03.2020 um 05:25 schrieb Stefan Knecht: Generally speaking, you don't want to do that, ever. It will render your database unsupported and possibly broken. Obj$ is an internal object that should never be modified in any way.

As Tim has said, why don't you state your observations, and how the problem you are experiencing manifests itself.

On Tue, Mar 31, 2020 at 7:17 AM Ali Alizadeh <<>> wrote: Hello expert
I am trying to defragment obj$ table.
Has anyone done this before?

I appreciate any suggestions !



zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework! Visit us at<> | _at_zztat_oracle |<> |<>


-- Received on Tue Mar 31 2020 - 14:33:11 CEST

Original text of this message