Re: Build Indexes as Scheduled task?

Prior to the latest version of Ascential, that was the process I used to handle the index stuff. The tool provided a way to 'shell out' to a sql script that handled the Oracle-side pre and post processing ( 1 for each, obviously) - we also used this technique as an interim stage between load routines to run stored procedures that prepared load tables for the next step..
The new version allows us to program the sql within the job itself without having to shell out.

In Pl/Sql you would need to use dynamic sql to do DDL, but it should work ok..

iain.dickens_at_wgrant.com (Iain Dickens) wrote:

>Hi,
>
>ETL (informatica) is on Win2K and does have pre/post session where I
>can call batch file that runs scripts to drop/build indexes. This is a
>little messy as I have to maintain batch files, SQL files and ensure
>if ETL schedules are altered that the PRE/POST session is amended.
>I was hoping to submit from DBMS_JOBS and maintain only two procedures
>(drop and create) where I can apply conditions at database level. As
>PL/SQL does not support DDL directly I am really looking for an
>alternative where I maintain 2 procedures (or similar). But obviously
>less maintenance than post session from ETL tool.
>It may well be I would be better sticking to what I have at the moment
>as it does work.
>
>Thanks
>
>Iain

-----------== 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 Tue Aug 27 2002 - 08:45:00 CDT