Re: Tablespaces?

nss_at_csc.liv.ac.uk (N.S. Smith) wrote:

>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?

I would keep the students right away from the system tablespace. I would create a student tablespace as you have suggested.

> 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

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP
25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555
Email gordonh_at_acslink.net.au
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ We are just two lost souls living in a fish bowl Year after year

Pink Floyd Received on Tue Aug 20 1996 - 00:00:00 CEST