Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Scheme on Oracle
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 ?
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:33:00 CDT