Re: max extents reached on system table

jatras_at_csn.net (Andy Jatras) wrote:
>On a v7 oracle database, i have reached the max extent (99)
>on the system table OBJAUTH$. I get the error 'max extents exceeded'
>if i try to grant to a table.
>
>When i try to do an import (with GRANTS=N and FULL=Y) for this table
>it fails with an error that the table OBJAUTH$ already exits.
>
>I am not sure if i can drop a system table, and i am not
>sure what the consequences of doing so would be.
>
>Any help would be appreciated.
>
>Andy Jatras
>303.624.0016

Andy, you can alter the tables maxextents with ALTER TABLE OBJAUTH$ STORAGE( MAXEXTENTS 249); While you are at it you may want to increase the NEXT parameter and make sure the PCTINCREASE is 0.

Jim Received on Mon Oct 30 1995 - 00:00:00 CET