Re: Quest on setting up Oracle 9i...

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sun, 12 May 2002 10:48:22 +0100
Message-ID: <3cde3a65$0$238$cc9e4d1f@news.dial.pipex.com>

take a look at the Oracle concepts manual which is a good place to start.

assuming you have created the example database to create a user log on as system and issue the following using sql*plus

create user jkutey identified by password default tablespace users
temporary tablespace temp;

then you can read up about waht privileges you might want to grant the user so it can actually do things.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<jkutey_at_nospam.nycap.rr.com> wrote in message
news:h4irducgs8mtes60u01dlhmtffh2dv1u83_at_4ax.com...


> Hi all. I am new to Oracle 9i. I am a college student, studying

> Oracle. I have just finished loading Oracle 9i on my home pc, along

> with the  Forms and Reports CD. How do I go about creating a valid

> user and password, so that I may create, and edit tables at home. I

> plan to copy all pertinent text  to notepad, and transfer them to the

> school's database, so that I may execute them there. I just want to be

> able to simulate the database at home.

>

> Thanks

>

> John

Received on Sun May 12 2002 - 04:48:22 CDT