Build Indexes as Scheduled task?

From: Iain Dickens <iain.dickens_at_wgrant.com>
Date: 26 Aug 2002 07:34:35 -0700
Message-ID: <42d2ae6c.0208260634.2b906f62@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 Received on Mon Aug 26 2002 - 09:34:35 CDT