Re: ORA-00904 with dbms_metadata.get_ddl

From: <gareth_at_jamms.org>
Date: Wed, 1 Apr 2009 08:53:50 -0700 (PDT)
Message-ID: <5986db57-f14c-4c49-9def-795a13d1a192_at_r37g2000yqn.googlegroups.com>

On 1 Apr, 16:22, Ste <s..._at_ste.it> wrote:
> Hi all,
>
> does anyone have seen the following problem:
>
> SQL> select dbms_metadata.get_ddl('INDEX',MYINDEX) from dual;
>                           *
> ERROR at line 1:
> ORA-00904: invalid column name
>
> Metalink is not able help me, and google so far...
>
> Thanks
> Steve

You're missing quote marks around your index name. Try:

SQL> select dbms_metadata.get_ddl('INDEX', 'MYINDEX') from dual;

HTH -g Received on Wed Apr 01 2009 - 10:53:50 CDT