| Oracle 9.2 [message #54115] |
Wed, 30 October 2002 11:57  |
newbie2
Messages: 8
Registered: October 2002
|
Junior Member |
|
|
Hello,
I just installed Oracle 9.2 on a Windows 2000 server and for some reason, alot of my sys and system objects
are invalid. I ran a dynamic script to find them all and then I compiled them but they are still invalid.
What have I done wrong?
|
|
|
|
| Re: Oracle 9.2 [message #54121 is a reply to message #54115] |
Wed, 30 October 2002 17:24  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Look at the install.log files created in your ORACLE_HOMEadmincreate directory. There should be an explanation.
Try to recompile with:
@?/rdbms/admin/utlrp.sql
or run
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
one more time.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
