Re: Tablespaces?
Date: 1996/08/16
Message-ID: <4v0q8p$p7_at_mari.onr.com>#1/1
Setup a single tablespace for your users (named USER, USERS, STUDENTS or whatever), but do NOT allow them to create object in the SYSTEM tablespace.
Make sure you assign new users to the appropriate tablespace as part of the CREATE USER command [DEFAULT TABLESPACE ...].
In article <Dw6I55.8F9_at_csc.liv.ac.uk>, nss_at_csc.liv.ac.uk says...
>
>Hi,
>
>An almost trivial question on tablespaces I suspect but
>here goes:
>
>I'm looking to create student accounts on our Oracle
>teaching system (just installed). Whats the form for
>student tablespaces? Should I give them the default
>SYSTEM tablespace, do I design a STUDENT tablespace
>and assign them all to that, or should they get their
>own individual tablespace? There will be about 100
>of them, and the accounts will last for about 2 weeks
>each.
>
>We're using HP worksations running HP Unix 9.X, and
>Oracle server 7.2.3. E-mail reply preferred.
>
>Thanks
>
>Neville
Received on Fri Aug 16 1996 - 00:00:00 CEST