Re: Sample database

Peter Morris wrote:

> "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)
> >
> >

The semantics are not knitpicking. Speaking Bantu in Kansas will not get you directions to a restaurant and asking for something other than what you want in an Oracle usenet group will get you bad advice. Now at least I, and others, can help you.

First advice ... go to http://tahiti.oracle.com and read the concepts manual. Oracle's architecture and concepts are very different from those of Informix.

Second advice ... while 8.1.7 only installs the SCOTT schema there is enough SQL to build just about anything you want on your hard disk. Start at c:\oracle\ora81 and search for files with the .sql extension. You will find hundreds and among them files such as sdowkt.sql which is 500K of insert statements. Many of the .sql files will be in directories with names like demo, example, and sample. You can use any of them.

Just create a new user, log on as that user, and run one or more scripts.

If you need advice on how to do this just ask.

--
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)