Re: getting DDL for all indexes on a table (using dbms_metadata.get)

On 21 May, 15:09, GS <G..._at_GS.com> wrote:
> Thanks - but the schema that owns the table does not have create session
> priv's, so I need to run this from system schema, and this examples does
> not work..- Hide quoted text -
>
> - Show quoted text -

Simply apend the schema name:

SELECT DBMS_METADATA.GET_DEPENDENT_DDL('INDEX','TEST', '<schema_name'>) FROM DUAL;

HTH -g Received on Wed May 21 2008 - 09:23:21 CDT