Re: Create Schema

From: <michael_bialik_at_my-deja.com>
Date: Sat, 24 Jul 1999 17:02:06 GMT
Message-ID: <7ncria$evb$1@nnrp1.deja.com>

Hi, Nadia.

You have to create an USER :

CREATE USER SUMMER IDENTIFIED BY <your-user-password> DEFAULT TABLESPACE <tablespace-name>
TEMPORARY TABLESPACE <temp-tablespace-name>;

GRANT CONNECT,RESOURCE TO SUMMER; Good luck. Misha.

In article <7n9jrk$45a_at_freenet-news.carleton.ca>, cy913_at_FreeNet.Carleton.CA (Nadejda Maslennikova) wrote:
>
> Hi,
> I connect to the database as SYS and want to create new schema SUMMER.
>
> I write
>
> CREATE SCHEMA AUTHORIZATION SUMMER
>
> It doesn't work, compiler gives a mistake.
> Any ideas? What do I do wrong?
>
> Thanks!
> Nadia
> --
> email: cy913_at_freenet.carleton.ca
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jul 24 1999 - 12:02:06 CDT