iain.dickens_at_wgrant.com (Iain Dickens) wrote in message news:<42d2ae6c.0208260634.2b906f62_at_posting.google.com>...
> Hi,
>
> Oracle 8.1.7 on W2K.
>
> Running a DWH performing large inserts each night via ETL tool. In
> order to speed up load it makes sense to drop/recreate indexes as pre
> & post jobs. Currently using 3rd Party scheduling tool to do this.
> Would ideally like to call procedure from DBMS_JOBS as part of
> Procedure which can validate completion of overnight jobs prior to
> recreation of Indexes. Can't get DDL to run from Procedure...any
> ideas????
>
> Thanks
Lain, how did you try to execute the DDL? Did you use Execute
Immediate, dbms_sql, or just try to code the create inside pl/sql?
Since DDL is not supported in pl/sql you have to use one of the two
dynamic SQL features mentioned at the start of the second question.
You can find examples of using Execute immediate in the pl/sql manual.
Received on Mon Aug 26 2002 - 15:34:14 CDT
