Re: 3 dba questions

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.