Re: Database Creation Problem

From: Mikel <notreally_at_me.com>
Date: Thu, 6 May 1999 22:08:03 -0400
Message-ID: <y0sY2.133319$Mb.52796828@newscontent-02.sprint.ca>

Arthur

I know in 8 and I think in 7, if you create a db using the db assistant, it will run the correct scripts. I believe you can create a db using the assistant, but instead of creating the db, you can save the script that creates the db. Look at this script and it should give you a clue as to what you may have missed. You can also check out the BUILD_DB.SQL script located in ORACLE_HOME\RDBMS80\ADMIN.

Mikel

art_merar_at_my-dejanews.com wrote in message <7gmu3l$6tr$1_at_nnrp1.dejanews.com>...
>
>
>
>Hello,
>
>I created a database under Oracle 7.3.3. Everything went fine until I
tried
>to go into SQL*PLUS. I got lots of message about packages not loaded and
>such. So, after some reading, I ran CATALOG, CATDBSYN, STANDARD, DBMSSTDX
and
>CATPROC. Now, when I try to go into SQL*PLUS, it just sits there and
hangs.
>It never goes into SQL*PLUS. What have I done wrong? Do I need to
re-create
>the database?
>
>What the the SQL scripts that need to be run when you manually create a
>database?
>
>Please send replies to: amerar_at_ci.chi.il.us
>
>Thanks for your help,
>
>Arthur
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu May 06 1999 - 21:08:03 CDT