Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Scheme on Oracle
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA7027F8B7C_at_lnewton.leeds.lfs.co.uk...
> 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 ?
Ticking along, quietly in the background. Meanwhile, I've moved onto more difficult things... how does a 2-node RAC on 2 Windows 2K Pro Virtual Machines on a single XP Pro host grab you?
Regards
HJR
>
> -------------------------------------
> 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 - 06:51:39 CDT