Re: Scheme on Oracle

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 - 04:35:40 CDT