Re: How can I create an oracle schema?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 30 Oct 2004 08:26:37 -0700
Message-ID: <1099149938.521200@yasure>

Howard J. Rogers wrote:

> Guillermo Uriarte wrote:
>
>

>>How can I create an oracle schema?

>
>
> This must take some sort of prize for 'most asked question'.
>
> You create a schema by creating a user.
>
> The command for which is:
>
> create user fred identified by password
> default tablespace X temporary tablespace Y quota 0 on system;
>
> Though you could actually stop after the 'identified by password' bit.
>
> HJR
Unless working in 10g in which case you will want to add:

quota 0 on sysaux;

too.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Sat Oct 30 2004 - 10:26:37 CDT