it's CHECK_OBJECT, not CHECK_OBJECTS
On 7 Dec, 21:33, "supernova" <nova..._at_yahoo.de> wrote:
> Hi,
>
> i'm trying to run the DBMS_REPAIR check routine but i get a PLS-00302
> error.
> Can any1 help?
>
> thks, Andy
>
> SET SERVEROUTPUT ON
> DECLARE CORRUPTED_BLOCKS INT;
> BEGIN
> CORRUPTED_BLOCKS := 0;
> DBMS_REPAIR.CHECK_OBJECTS(
> SCHEMA_NAME => 'SH1' ,
> OBJECT_NAME => 'ACSALES',
> REPAIR_TABLE_NAME => 'REPAIR_TABLE1',
> CORRUPT_COUNT => CORRUPTED_BLOCKS
> );
> DBMS_OUTPUT.PUT_LINE('You have ' || TO_CHAR(CORRUPTED_BLOCKS) || '
> corrupt block(s)');
> END;
> /
>
> Error at line 2
> ORA-06550: Ligne 4, colonne 13 :
> PLS-00302: Le composant 'CHECK_OBJECTS' doit être déclaré
> ORA-06550: Ligne 4, colonne 1 :
> PL/SQL: Statement ignored
Received on Thu Dec 07 2006 - 14:42:03 CST
