Re: max extents reached on system table
Date: 1995/11/02
Message-ID: <47bhpp$g6k_at_zippy.cais.net>#1/1
Andy Jatras (jatras_at_csn.net) 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
a more important question is why your system space has been used up? Are you running AUDITing? If you are - then you probably have not purged the audit tables, thus letting the sys area fill up. First chaeck this, then purge the audit trail then you should have enough room.
Just a guess...
Randy
-- ..uu. ---------------------- .?$" '?i . I Randy DeWoolfson I .T^M ._at_" d9 . f ,.un. b, i I--------------------I " Z :#" M `8 U < .dP"``"# `M _at_" I randyd_at_cais.com I &H?` Xl _R $5. $ ?* _at_ 'P,#" I--------------------I ,d#^*L :RP'~$b f`$L:M Xf .f' dH` I ,\//. I & 'M ,P `E M "$ Mux~ n!` I |o o| I dk `h" ' j " y" *~ I====oOO==(_)==Ooo===IReceived on Thu Nov 02 1995 - 00:00:00 CET