Re: 3 dba questions
From: Graeme Sargent <graeme_at_pyra.co.uk>
Date: Fri, 7 Jan 1994 11:22:01 GMT
Message-ID: <1994Jan7.112201.28589_at_pyra.co.uk>
Date: Fri, 7 Jan 1994 11:22:01 GMT
Message-ID: <1994Jan7.112201.28589_at_pyra.co.uk>
In <TIM.94Jan4165152_at_sun1.claremont.com> tim_at_sun1.claremont.com (Tim Maggio) writes:
>Why is it you can create a database without a name?
Why not? Most people prefer to use database name == instance name in any case.
I haven't tried it with OPS (where you have different instances accessing the same database) though. Does anybody know if this would cause problems? I think it should be OK, since anything which looks dodgy would have to be done while in exclusive mode.
>How is the default_tablespace and temporary_tablespace specified for a user?
> (note: select * from dba_user;)
With CREATE USER (or ALTER USER).
>How are multiple users added to a database?
With CREATE USER.
graeme
-- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme_at_pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.Received on Fri Jan 07 1994 - 12:22:01 CET