Skip to Content

Invalid object

Hi,

in a BI system just copied I found some invalid object, I post the output of : SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';

/BI0/0400027280

/BI0/0400003010

/BI0/0400018987

/BI0/0400002996

/BI0/0400007708

/BI0/0400031992

/BI0/0400027879

/BI0/0400027880

/BI0/0400027128

/BI0/0400027852

/BI0/0400027853

/BI0/0400027906

/BI0/0400027907

/BI0/0400029629

All obj are PROCEDURE and are in ABAP schema... I try with: alter <object_type> schemaname.<object_name> compile;

withour success ... Oracle see: procedure not found.

Any idea ?

Regards.

Ganimede Dignan.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 30, 2008 at 09:49 AM

    Oracle 10.2.0.2 patch 17 Win 32.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded