Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database example

Re: Database example

From: Herman Rollfs of Roelofs <roelofs223_at_zonnet.nl>
Date: Wed, 16 Jul 2003 17:40:02 +0200
Message-ID: <rleRa.6725$w3.1827618@zonnet-reader-1>


"Fiber Optic" <fiberoptic_at_go2.pl> wrote in message news:bf2d2e$353$1_at_nemesis.news.tpi.pl...
> > Start by dropping the SQL Server lingo and learning Oracle concepts. A
> database
> > in SQL Server is a SCHEMA in Oracle: You can't download a database
example
> > because no such thing exists. You would be asking to download a group of
> > datafiles sized in the hundreds or thousands of megabytes.
> >
> > If you have Oracle installed tell us which version. All Oracle
> installations
> > have demo schemas with them. Start by looking at c:\oracle\ora92\demo or
> its
> > equivalent.
> >
> > --
>
> I have Oracle 9.2.0.1.0 on W2k. Please, tell my how to create good lab
> enviroment to learn Oracle concept.
>
> Thanks,
> FO
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.501 / Virus Database: 299 - Release Date: 7/15/2003
>
>

Oracle has tools to create a database. A database may already have been created when you installed oracle. Most databases include a sample schema called scott with password tiger. You can try starting sqlplus and logging in with scott/tiger. If it asks for a database, you may enter orcl. This may or may not work, depending on how you installed oracle. Take a look at the installation manuals.
This may work (or not) as a quick start. The other posts here are right about reading the concepts manual first. See your distribution or otn.oracle.com.

Herman Received on Wed Jul 16 2003 - 10:40:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US