Re: Sample database

Hey Morgan, quit speaking for others you freak!

Daniel Morgan wrote:

> 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)
Received on Wed May 21 2003 - 21:38:53 CDT