Re: Creating an Oracle Database for the first Time

On 23 Aug 2006 18:16:02 -0700, "wiinc1" <brianwuollet_at_gmail.com> wrote:

>Hi All,
>
>I have recently received the Oracle 8i software and have always created
>databases via MS Access. I have grown tried of there lack of
>performance when it comes to querying large volumes of data so I want
>to take a stab at teaching myself Oracle as I taught myself Access. At
>first glance, it appears considerably more difficult as I don't even
>know where to begin.
>
>I have read some posts here and gather that I need to use SQL Plus
>which was provided in the software in order to begin. When I open this
>program, it asks for a username, password, and Host String. Any help
>here on what to do?
>
>Is there not a way to build an Oracle database on my hard drive? Do
>you know of any sites which may have examples of an Oracle database I
>could download and begin to look at as MS Access has (ie Northwinds).
>
>Thanks for any and all feedback.

There is a way creating a database, but really: one can't learn Oracle without reading any documentation.
Oracle 8i is way old (released in 1998), and desupported, so it would dump it, and look into getting Oracle 10g XE, which is much more GUI oriented than any older version.
However, in that case you still need to read the Oracle Getting Started info at http://tahiti.oracle.com In both versions there is a thingy called 'Oracle Database Creation Assistant' In 10g XE it is started automatically just after installation.

--
Sybrand Bakker, Senior Oracle DBA