Re: Creating an Oracle Database for the first Time

Thanks for all the replies to this subject.

My follow up question to your answer is the following: -If I go to download Oracle 10g, what functionality will be missing between 10g & 10g XE?

Thanks.

Sybrand Bakker wrote:
> 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
Received on Thu Aug 24 2006 - 08:24:51 CDT