Re: Tablespaces?

Ashi Chaturvedula <ashi_at_thomtech.com> wrote:
>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? 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
>
>
>use one tablespace for the students and make it their default tablespace-
>make it large enough.
>
>ashi

I don't have enough info to respond. What are the students going to be doing? What are you teaching? There is a management/space issue here for you are your support staff to consider. For Example if your simply teaching SQL or Introduction level then why not create one student tablespace all of there objects will be unique to their schema. ASHI is correct keep them seperated from the SYSTEM tablespace. Again if this not DBA training then make sure you have changed the SYS and SYSTEM passwords form the install.

Hope This Helps
R2
rmramos.gbs_at_worldnet.att.net
Independent Oracle Consultant Received on Sat Aug 17 1996 - 00:00:00 CEST