Error Message when running catproc

[Deanna Tran]

After running the catproc.sql script, it generated a lot of errors. this is one of them
ora 6509 dbms_application info, and the other
one was unable to extend the rollback segment..
after fixining the rollback back segment I ran
this script again? and it said at the end, the
package has created with compliation errors?
Can you show me how to fix this?
In addition, when i tried to use this
select * from database
error mesage comes back and said the table
or view does not exit?
Is there a command to check if my creation of the database was successfully done? and how can I view all the rows and columns in that database?
Thank you

[Jean-Luc Oudart]

Hi,

First, did you run catproc.sql as user SYS ?
if not, you may find your answer on Oracle metalink web site. search for doc id 1015902.4

Second, the command should be
select * from v$database.

For the list of tables, objects you can run queries against the DBA tables :
DBA_TABLES
DBA_OBJECTS
etc,...

JL

[Deanna Tran]

Hi Jean-Luc
I did run catproc.sql as system.
thanks for the tips on viewing the table.
I am in the processing of writting the loader script to fill up that table space, can you hlep me on how to determine the type of the datafile that needs to be fill? and how would I go about to view those information?