Oracle supplies an excellent set of sample schemas that you can use to play
with a lot of the different functionality. If you successfully installed
Oracle go to the OracleHome / demo / schema folder and check the
mksample.sql script. This will set the schemas up for you. In Oracle's
documentation (included on one of your CDs ) is a complete book on the
sample schemas called "Sample Schemas".
"PWalker" <p.walker_at_rad.com> wrote in message
news:41f2538a$1_at_dnews.tpgi.com.au...
> Thank you for the clarification, much appreciated!
>
> peter
>
> "Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in
> message news:5hc4v0577hvq11ibd867vkd49b9scnhpb8_at_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 - 12:22:42 CST
