Database Administration (MOSC)

MOSC Banner

UTLRP cannot recompile "recompilable" objects

edited Nov 24, 2010 4:58AM in Database Administration (MOSC) 10 commentsAnswered
Hello,
I have a weird behaviour with utlrp; strange enough, I've discovered this recently although I use utlrp since years

test case: (Oracle 9.2.0.7)
as "SCOTT":
CREATE TABLE a( id NUMBER );
Table created.
CREATE TABLE b( id NUMBER );
Table created.
CREATE OR REPLACE VIEW ab AS
 SELECT a.id
   FROM a
   INNER JOIN b
     ON a.id =b.id;
View created.

Now we make the view invalid (by "touching" an underlying table)
ALTER TABLE b MODIFY( id NOT NULL );
Table altered.
SELECT status
  FROM user_objects
  WHERE object_name = 'AB'
    AND object_type = 'VIEW';
STATUS
-------
INVALID


Now, as SYS, I run "utlrp" to recompile all the invalid objects...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center