Home » SQL & PL/SQL » SQL & PL/SQL » Compilation based on dependency
Compilation based on dependency [message #20449] Fri, 24 May 2002 23:45 Go to next message
sai krishna
Messages: 8
Registered: July 2001
Junior Member
Hi,

I am unable to compile invalid objects.

Can any one help me in the compilation based on the dependency.

Table order_object_by_dependency doesn't exist in sys of oracle 8.1.7.

please help.

thanks in advance.
sai.

Report message to a moderator

Re: Compilation based on dependency [message #20450 is a reply to message #20449] Fri, 24 May 2002 23:58 Go to previous message
K.senthilkumar
Messages: 6
Registered: May 2002
Junior Member
Hi sai
In oracle 8.1.7 order_object_by_dependency
is not available. Instead ORACLE_HOME/rdbms/admin/
utlrp.sql file is there.
Just you run this script in your session.
It will compile all the invalid objects
based on the order wise.

Report message to a moderator

Previous Topic: How to generate test data in PLSQL
Next Topic: SQL Count Statement
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 20:41:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.