Re: Just Installed But Now Shrugging

Daniel A. Morgan wrote:
>For someone seemingly clue less you did a remarkably good job. Catproc.sql was the
>right script to run.

Or stupid luck ;-P

Well, it's doesn't matter now; I didn't create public rollback segments. I have wiped clean and starting anew. I've walked into and tripped over *every* trap there is(which I think is a Good Thing since I'm just hacking) But I actually got to the point where I created a table!

> Anything related to Oracle 6 is useless and most of 7 not
>worth reading though much is similar.

Actually the SQL 6 book has served well enough with groups.google.com supplimenting.

>I strongly urge you to do
>what you should have done in the first place. Read the installation instructions on

I can't remember where I got the CD but it was a Red Hat promotional mailer or insert. It's got a REALLY crappy Java installer that chokes at every turn(at one point I was laughing out loud). The "Intallation Guide" wouldn't help me prime a campfire.

>the CD and buy a good beginners DBA book and PL/SQL programming book.

Is Teach Yourself PL/SQL In 21 Days so bad that I should go out and buy something else? I could probably dig up a coffee stained PL/SQL manual for Oracle 7, how's that? I found a recommendation for 'Oracle: The Complete Reference' by Koch and Loney. What do you recommend for Oracle DBA and PL/SQL texts?

>This group can help you and provide support ... but it can not possibly get you
>from where you are to where you need to be.

Ok, well, one more question(it's a specific one this time):

Regarding sql files to run after creating a new database, I know it's roughly:

connect internal

@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
@$ORACLE_HOME/rdbms/admin/catdbsyn.sql

connect system/change_on_install
@$ORACLE_HOME/sqlplus/admin/pupbld.sql

What else and in what order?

Thanks for your help,
Mike Received on Sat Jun 23 2001 - 02:49:42 CDT