Re: new to oracle 9i

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Sat, 22 Jan 2005 12:02:57 +0100
Message-ID: <5hc4v0577hvq11ibd867vkd49b9scnhpb8@4ax.com>

On Sat, 22 Jan 2005 19:27:17 +1000, "PWalker" <p.walker_at_rad.com> wrote:

>Hi, I have a few basic questions to ask:
>
>1. does oracle 9i come installed with a 'demo' database? I thought it did
>but i saw no demo database once i finished installing 9i
>
>2. Is it possible to determine which column within a table is a PL or FK
>from the enterprise manager console alone? or do i have to write some script
>to tell me which are the pk and fk's for a table
>
>Many thanks!
>peter
>

Apparently you didn't pay attention during installation and you didn't read the getting started manual.
You can set up a starter database during installation (in fact you are prompted for it) and you can install several demo *schemas* (The Oracle equivalent of a sql server database is a *schema*)

2 You'll need to write a script.

BTW: Oracle <> Sqlserver. You won't get very far if you never read manuals.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Jan 22 2005 - 05:02:57 CST