Re: schema creation

From: <1alistair1_at_my-deja.com>
Date: Thu, 04 Nov 1999 15:45:29 GMT
Message-ID: <7vs9mn$t7p$1@nnrp1.deja.com>

Try selecting the 'create as...' menu item when creating a user, you will then see the syntax. It should look something like:

create user scott identified by tiger
default tablespace user_data
temporary tablespace temp;

grant connect,resource to scott;

Hope this helps

Alistair Thomson

In article <7vjss3$qir$1_at_nnrp1.deja.com>, npomfret2_at_my-deja.com wrote:
> Is there an Oracle tool which produces creation scripts for an already
> existing schema? I've tried Schema Builder but the show SQL option
> just gives me an empty grey text area.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 04 1999 - 09:45:29 CST