Re: Sample database

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3ECAEF4D.8B81B9CA_at_exxesolutions.com...
> > As I understand it, the term 'database' refers to an organised
> > collection of data, and 'schema' means a description of how
> > the data is arranged.
> >
>
> Then, in Oracle, you understand incorrectly. In Oracle a database is the
> collection of files that include the data files from which the tablespaces
are
> logically constructed, the control files, and the log files.

What's the difference between that and 'an organised collection of data' then?

Terminology nipicking aside, I need the data files to create a set of tables and fill them with data.

> What you are asking for is a schema and you don't need one. What you need
to do
> is either log on as one of the sample schemas already installed in your
database
> or create one yourself.

It would take quite a bit of time to think up a fictional database and enter loads of fictional data. The EMP/DEPT database is a little small for my purposes. Are there any others?

> It sounds like you have minimal, if any, Oracle experience

Actually, I have a lot of programming experience on a variety of database platforms, that is my experience has been mostly writing stored procedures, triggers, and so on. Now I wish to learn some DBA skills. I have previously done some DBA stuff on Informix, but not on Oracle.

And before you say it, no my company can't send me on a course, because it went bust and I'm currently unemployed.

> so start out by
> answering the following questions to help others help you.
>
> What hardware platform and operating system?

PC with Windows XP Profesional

> What version and edition of Oracle?

Oracle 8i Enterprise Edition 8.1.7.0.0

> Can you log on? If so as what users?

sys/ change_on_install
system/ manager
scott/ tiger

or I can create my own login.

> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Wed May 21 2003 - 07:52:15 CDT