Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Error Message when running catproc

Deanna Tran
Frequent Advisor

Error Message when running catproc

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
2 REPLIES
Jean-Luc Oudart
Honored Contributor

Re: Error Message when running catproc

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
fiat lux
Deanna Tran
Frequent Advisor

Re: Error Message when running catproc

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?