Re: SYSTEM Tablespace is FULL
Date: 6 Sep 2003 16:20:53 -0700
Message-ID: <2687bb95.0309061520.2195c62c_at_posting.google.com>
kuljeet_twtpl_at_hotmail.com (KULJEET) wrote in message news:<febbed51.0309052004.2d6f4f4e_at_posting.google.com>...
> no problem
> it will automatically increase
Before expanding the SYSTEM tablespace you should find out what is using it! If the list of tablespaces your listed is complete then you need to add a temporary segment (sort) tablespace and a Rollback Segment (rbs) tablespace unless the two other tablespaces shown server these purposes.
The Concepts manual has a decent chapter on physical/logical database setup.
If you are missing a temp segment TS then after creating one: alter user username temporary tablespace temp [or whatever name you give it, but temp or tmp are the most traditional names] for every user other than SYS.
HTH -- Mark D Powell -- Received on Sun Sep 07 2003 - 01:20:53 CEST