Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Scheme on Oracle

Re: Scheme on Oracle

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 13 Aug 2002 21:51:39 +1000
Message-ID: <3d58f9c4@dnews.tpgi.com.au>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US