Re: How can I create an oracle schema?

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