Results 1 to 3 of 3

Thread: DBMS_DDL Error

  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Question Unanswered: DBMS_DDL Error

    when the package dbms_ddl is used, I get an error message as given below .

    Pl SQL Code :

    begin
    dbms_ddl.analyze_object('table','scott','emp','com pute');
    end;


    error message :

    ERROR at line 1
    ORA-20000: Unable to analyze table "scott"."emp", insufficient privileges or does not exist
    ORA-06512: at "SYS.DBMS_DDL",line 192
    ORA-06512: at line 2

    ----------------------------------

    I have checked and the table does exist under the same schema(viz. SCOTT). So I think it is a privilege problem. What may be the privileges( other than the owner privilege) that may be required for the succesful execution of this PL/SQL code???

    TIA for assistance

  2. #2
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    140
    Does your user has the right to execute package dbms_dll ?

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    HI,

    The table name and schema name have to be in the correct case for the package to work.

    dbms_ddl.analyze_object('TABLE','SCOTT','EMP','COM PUTE');

    Parameter descriptions for the ANALYZE_OBJECT procedure specifies the SCHEMA and object NAME are both case sensitive.
    SATHISH .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •