Re: A Newbie Question...

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 - 11:34:54 CDT