Re: table_space problem

From: David Bath <dtb_at_otto>
Date: 22 Mar 93 12:38:27 GMT
Message-ID: <dtb.732803907_at_otto>


dhiltz_at_whsun1.wh.whoi.edu (David Hiltz) writes:
> I wonder if its complaining about temporary space used for things like
> sorting? Is your temporary tablespace TEMPUSERS, SYSTEM, or something
> else? Mine is SYSTEM.

Personally, I think having SYSTEM for either user data or temporary tables is a bad move. You only need one runaway query or a naughty user to do something nasty to your database.

I like keeping the SYSTEM tablespace for SYSTEM stuff. Each application then has its own tablespace and different classes of users have different temporary and permanent tablespaces. I like firewalls.

-- 
David T. Bath             | Email:dtb_at_otto.bf.rmit.oz.au (131.170.40.10)
Senior Tech Consultant    | Phone: +61 3 347-7511 TZ=AEST-10AEDST-11
Global Technology Group   | 179 Grattan St, Carlton, Vic, 3153, AUSTRALIA
"The robber of your free will does not exist" - Epictetus
Received on Mon Mar 22 1993 - 13:38:27 CET

Original text of this message