Re: getting DDL for all indexes on a table (using dbms_metadata.get)
From: GS <GS_at_GS.com>
Date: Wed, 21 May 2008 15:59:35 GMT
Message-ID: <HFXYj.4199$KB3.11@edtnps91>
>
> Simply apend the schema name:
>
> SELECT DBMS_METADATA.GET_DEPENDENT_DDL('INDEX','TEST',
> '<schema_name'>) FROM DUAL;
>
> HTH
>
> -g
>
>
got it, that did the trick
Date: Wed, 21 May 2008 15:59:35 GMT
Message-ID: <HFXYj.4199$KB3.11@edtnps91>
gazzag wrote:
> 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
>
>
got it, that did the trick
thanks! Received on Wed May 21 2008 - 10:59:35 CDT