Re: table_space problem
From: David Bath <dtb_at_otto>
Date: 22 Mar 93 12:38:27 GMT
Message-ID: <dtb.732803907_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" - EpictetusReceived on Mon Mar 22 1993 - 13:38:27 CET