Re: Scheme on Oracle

Agreed. And why not a default default tablespace?

Paul

"Richard Foote" <Richard.Foote_at_oracle.com> wrote in message news:3D58D2EC.351DC9C8_at_oracle.com...
> Hi Norman,
>
> Except in 9i where the temporary tablespace clause is somewhat
> redundant.
>
> Because of course we ensure we create a default temporary tablespace
> when we create the database :)
>
> Cheers
>
> Richard
>
> Norman Dunbar wrote:
> >
> > Or even better :o) ...
> >
> > create user fred identified by <password>
> > default tablespace <something that is not SYSTEM>
> > temporary tablespace <probably temp>
> > quota 0 on SYSTEM
> > quota <some value> on <tablespace defined as being the default one>;
> >
> > Grant create session, create table, create view, create trigger, create
> > sequence, create procedure to fred;
> > (which could be better done through a role).
> >
> > Never create a user without specifying a default tablespace and a
> > temporary tablespace because these default to SYSTEM and you do not want
> > any user objects in the system tablespace.
> > And make sure that the temporay tablespace is indeed a tempoary one
> > otherwise all your sort segments have to be allocated and deallocated -
> > which is a killer.
> >
> > Cheers,
> > Norman.
> >
> > PS. Morning Howard - how goes the land management system ?
> >
> > -------------------------------------
> > Norman Dunbar
> > Database/Unix administrator
> > Lynx Financial Systems Ltd.
> > mailto:Norman.Dunbar_at_LFS.co.uk
> > Tel: 0113 289 6265
> > Fax: 0113 289 3146
> > URL: http://www.Lynx-FS.com
> > -------------------------------------
> >
> > -----Original Message-----
> > From: Howard J. Rogers [mailto:howardjr2000_at_yahoo.com.au]
> > Posted At: Tuesday, August 13, 2002 9:36 AM
> > Posted To: server
> > Conversation: Scheme on Oracle
> > Subject: Re: Scheme on Oracle
> >
> > Create user fred identified by password;
> >
> > In Oracle, a schema = a user (sort of). So to create a new schema, you
> > create a new user.
> >
> > Regards
> > HJR
> >
> > "Tom" <thomas.wettstein_at_ascom.ch> wrote in message
> > news:1e216733.0208130017.2450ed41_at_posting.google.com...
> > > Can everyone help me. I want create a new Scheme, but I see no way to
> > do
> > this.
> > > I have Oracle DBA Studio 8.1
> > >
> > > Thanks for help
> > > Tom
Received on Tue Aug 13 2002 - 15:56:38 CDT