Re: Just want to use SQL*Plus, please help a student :)

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Thu, 09 Nov 2000 00:05:26 GMT
Message-ID: <3a09e948.728220265@news.alt.net>

On Wed, 08 Nov 2000 23:48:11 GMT, "Fredrick Berning" <berningf_at_ucs.orst.edu> wrote:

>I downloaded and installed Oracle 8 Enterprise on my Win2k machine. I am a
>student and all I really need is SQL*Plus. How do I set up an account so
>that I can login into SQL*Plus? Any help is greatly appreciated.
>
>Fredrick
>
>

You can login as sys/manager and create an account.

sqlplus sys/manager

CREATE USER <username> IDENTIFIED BY <password>; GRANT CREATE SESSION TO <username>;
exit

If you actually want to create tables, you will space in a tablespace. Check the Oracle tools

Storage Manager to create a tablespace
Security manager to create/modify users and their rights.

Or learn the SQL statements you need from the documentation.

Brian Received on Wed Nov 08 2000 - 18:05:26 CST