To Rebuild / Reorganize Sys.Con$ To Reduce Its Size-783722.1

rongshiyuan發表於2013-01-23
Rebuild

Is It Possible To Rebuild / Reorganize Sys.Con$ To Reduce Its Size? [ID 783722.1]

In this Document
Goal
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.2
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.1.0.2 to 11.2.0.1.0

Goal

Is it possible to rebuild / reorganize SYS.CON$ to reduce its size?


Solution

It is not possible to rebuild / reorganize this base table as it is needed at all times while the instance is open

SQL> RENAME CON$ TO CONS$ ;
RENAME CON$ TO CONS$
*
ERROR at line 1:
ORA-00701: object necessary for warmstarting database cannot be altered

A cumbersome alternative would be to create a new database ... then move the users and their
objects to the new database using Transportable Tablespace (for the data) and Export / Import (for
the users and their non storage objects)





來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-753109/，如需轉載，請註明出處，否則將追究法律責任。

相關文章