Re: new to oracle 9i

Van Messner wrote:

> Oracle supplies an excellent set of sample schemas that you can use to play
> with a lot of the different functionality. If you successfully installed
> Oracle go to the OracleHome / demo / schema folder and check the
> mksample.sql script. This will set the schemas up for you. In Oracle's
> documentation (included on one of your CDs ) is a complete book on the
> sample schemas called "Sample Schemas".

Also look at demo.sql in /rdbms/admin.

But as Sybrand has said ... you must not have been reading the prompts during the installation and certainly not the installation instructions and in Oracle not reading is the road to disaster. Likely you already have them installed so log into SQL*Plus as SYS

SQL> / as sysdba

and run the following query:

SELECT username FROM dba_users;

If you see SCOTT, BI, HR, PM, etc. they are already there. Try logging into one of them:

SQL> conn scott/tiger

If successful great. If you get an error message that it is locked then:

SQL> conn / as sysdba

ALTER USER scott ACCOUNT UNLOCK;
ALTER USER scott IDENTIFIED BY tiger;

Should get you to the point you can log in. Do not ever do anything as SYS other than manage the database and if you can find a local college sign up for a class. It will be well worth the cost.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---