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: How can I create an oracle schema?

Re: How can I create an oracle schema?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 30 Oct 2004 09:30:47 +1000
Message-ID: <4182d294$0$32541$afc38c87@news.optusnet.com.au>


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 Received on Fri Oct 29 2004 - 18:30:47 CDT

Original text of this message

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