Re: Problem with system tablespace

On Aug 5, 11:54 am, "samz.dba" <sandeep.ma..._at_gmail.com> wrote:
> I have made a database in oracle 9i manually with three tablespaces
> System,undo and temp.Then i migrate system tablespace from dictionary
> managed.It was done.
> Now when i trying to get it back as dictionary managed it gives error.
> Is it possible to convert loaclly managed system tablespace to
> dictionary managed.
> Plz help me out
>
> Samz.dba

No, you cannot convert from a locally managed tablespace to a dictionary managed tablespace. I must agree with Howard here; why on earth you'd convert a perfectly good dictionary-managed SYSTEM tablespace to an LMT is a mystery to me. All of Howard's points are spot on:

You won't (or shouldn't) be dropping and creating objects in the SYSTEM tablespace thus segment reusability won't be a problem; these objects won't be extending indiscriminantly therefore fragmentation won't be an issue. There is, really, no good reason to convert a dictionary-managed SYSTEM tablespace to be locally managed.

You now have a locally-managed SYSTEM tablespace. Your choices are to live with what you've created, or drop the database and re-create it, this time leaving the SYSTEM tablespace as it is: dictionary-managed.

David Fitzjarrell Received on Mon Aug 06 2007 - 07:40:06 CDT