Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Build Indexes as Scheduled task?
What platform is your ETL tool running on and
doesn't it provide for before and after actions for scheduled jobs?
In my DWH load process my ETL tool ( DataStage from Ascential Software running on Solaris 8) runs my jobs in the early AM and drops the indexes before the job runs and recreates them after.
mark.powell_at_eds.com (Mark D Powell) wrote:
>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.
>
>-- Mark D Powell --
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Mon Aug 26 2002 - 15:57:09 CDT