Re: 3 dba questions

From: John Morgan <JOHN_Morgan_at_OIT.PEachnet.Edu>
Date: 5 Jan 1994 13:25:03 GMT
Message-ID: <2gef3f$h5u_at_news-feed-2.PeachNet.EDU>


In article <TIM.94Jan4165152_at_sun1.claremont.com> Tim Maggio, tim_at_sun1.claremont.com writes:
>Why is it you can create a database without a name?

I haven't tried this one (don't intend to start now, either!).

>How is the default_tablespace and temporary_tablespace specified for a
 user?
> (note: select * from dba_user;)

Default and temporary tablespace are always "SYSTEM", unless changed by the ALTER USER command.

>How are multiple users added to a database?

Well, I wrote a script (batch) file to do it...not too tough. Received on Wed Jan 05 1994 - 14:25:03 CET

Original text of this message