Re: New Schema not created - Newbie needs help!

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 21 Jun 1999 14:25:55 -0700
Message-ID: <376EADE3.67925076@exesolutions.com>

I don't find it odd at all?

since the person asking the question is new to Oracle they may be expecting something to be built that isn't.

If there are no errors in the user creation then I would suggest that a simple test such as:

CREATE TABLE XYZ (
test_field varchar2(20));

would be the next step. Now if that fails there is an actual problem.

Daniel A. Morgan

Srdjan Jovcic wrote:

> Robert Britton <brittonb_at_webt.com> wrote in message
> news:375be140_at_news.pcom.net...
>
> > When I create a new user it does not create the schema for that user.
>
> It is odd, shema and user are linked hard. Every user has one and only one
> schema, and any schema belongs to one and only user.
> Did that user get CONNECT and RESOURCE roles?
>
> djidoNOSPAM_at_eunet.yu
Received on Mon Jun 21 1999 - 16:25:55 CDT