Re: A Newbie Question...

Thanks Daniel, for taking time to clarify some of the fundamentals.

BTW _ Yes, you are correct about "scott/tiger" as described in the Oracle's 8i Beginner's book.

In fact, I forgot to mention to Den Hang's earlier response - That the installation process did go through complete Database Creation process. I just don't know what database and where did it create it.

I assumed that when I bring up SQLPlus - and log in as SYSTEM/password - I should be able to type in the syntax to check the datbase connecetd to and navigate through the databse using standard SQL queries. Next, I should also be able to check the number of connections as well some of the basic database engine fundamentals.

I don't think I need to read a thick book to get to these very basic startup questions - for somebody who has worked with DB engines before. I was hoping Oracle will have a standard 2-5 pager cheat sheets to help me get through the basics, that way I will at least feel that the DB engine is installed and working fine. Isn't that "Getting Started Manuals" is all about? One does not need to be an expert to get started. I suppose, I was spoiled working with IBM docs.

Anyway, eventually - like everybody else, I'll get it. I have alreday invested 6 GB of hard drive space so far - spinning software bits & bytes which I am trying to figure out. ( :-)

Hasmukh Daji

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D4EA925.18ABFB5A_at_exesolutions.com...
> Hasmukh Daji wrote:
>
> > Hi, - Need kick-start.....( Oracle's "Quick Start" does not do seem to
do
> > justice...).
> >
> > I have just finished installing the latest version of Oracle 9 Release 2
on
> > Win2K. I chose the Personal Edition install product. Although, I do have
an
> > extensive knowledge of SQL commands and the syntax, I could not figure
out
> > the some of the functionalities of with Oracle. I did read the Getting
> > Started Manual; but does not seem to answer my questions.
> >
> > The fundamental questions I have are:
> > (a) How can find out about the sample database installed? (Note: I
can
> > bring up SQLPLUS successfully).
> > (b) How can I find out which database I am connected to
automatically.
> > (c) I am still trying to grasp the concept of SYS and SYSTEM. How can
I
> > access database using my normal logon ID?
> >
> > I don't want to bore you with the list of my questions...... but the
final
> > one, which I thought was a joke..
> >
> > (d) After reading Oracle 101 from Oracle 8i Beginner's book (Oracle
> > Press..). It makes mention of login as polly/gone... They do not discuss
how
> > did "polly" get access to the database in the first place. Secondly,
when I
> > logged in as SYSTEM/<password>, I tried to create a sample databse using
> > "CREATE..." syntax, as described in the book. It came back with a
> > response....... "Tablespace does not exist.,..." At that point I lost
faith
> > in the authors, who put the book together. It mayt be a beginner's book
> > however, it assumes that your system is set up as per author's
> > specifications - without giving details of the setup anywhere in the
book.
> >
> > One of the most critical things about database installation is to
correctly
> > establish the logins and ensure that appropriate rights are set for
users to
> > log in. I have had previous experience working with IBM DB2 - I
certainly
> > did not run into these kind of fundamental issues.
> >
> > I would apprecaite a quick kick-start, so that I can at least start
working
> > with the package - especially, when it takes approx. 3GB of my hard
drive
> > space + 2 GB of install packages. Wow!!!!!!!!!!
> >
> > Hasmukh Daji
> > Atlanta, GA
> > hdaji_at_msn.com
>
> (a) The sample has traditionally been scott / tiger though I haven't
checked in
> 9.2.
> (b) Time to stop using SQL Server technology. You are connected to the
database
> you logged in to. The user you are connected as is quite another matter
and you
> can find that with: SELECT user FROM dual;
> (c) CONNECT username/password_at_database_name_as_aliased_in_TNSNAMES.ORA.
>
> (d) Polly got access to the database in the first place because SYS
created the
> user
>
> CREATE USER polly
> IDENTIFIED BY gone
> DEFAULT TABLESPACE tablespace_name
> TEMPORARY TABLESPACE temp -- well usually temp though there is no
guarantee
> QUOTA UNLIMITED ON tablespace_name;
>
> GRANT CREATE SESSION TO polly;
> GRANT CREATE TABLE TO polly;
> GRANT CREATE VIEW TO polly;
> GRANT CREATE PROCEDURE TO polly,
> GRANT CREATE TRIGGER TO polly;
> etc.
>
> To find out the available tablespaces for user tables and indexes ...
>
> SELECT tablespace_name
> FROM dba_tablespaces
> WHERE tablespace_name NOT IN ('SYSTEM', 'TEMP', 'RBS');
>
> Daniel Morgan
>
Received on Mon Aug 05 2002 - 21:19:30 CDT