Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database example
"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