Re: New to Oracle

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 22 Mar 2002 21:46:31 -0000
Message-ID: <3c9ba9dc_3@mk-nntp-1.news.uk.worldonline.com>

"Clyde Bryant" <cbryant_at_regalwood.com> wrote in message news:oFLm8.63$f17.47065_at_news.uswest.net...
> I have a question about how I can create a schema from and already
existing
> database. I'm coming from a Informix DBA background and creating a schema
> was pretty straightforward using the "dbschema" tool from the command
line.
> Is there similar tool in the Oracle world?
>
> Thanks in advance
>

Clyde,

I don't know Informix,
but in Oracle (up to 8i anyway),
a user is the equivalent of a schema,
so one usually creates a 'user' account
(normally an inaccessible 'dummy' one,
created solely to own the schema objects), then creates its objects,
which perforce reside within the schema.

Does this help? I can amplify if necessary...

Paul Received on Fri Mar 22 2002 - 15:46:31 CST