Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Script to build indexes in parallel

Script to build indexes in parallel

From: Charles Schultz <sacrophyte_at_gmail.com>
Date: Tue, 18 Dec 2007 15:43:52 -0600
Message-ID: <7b8774110712181343iea1f042l183452b6bac4049f@mail.gmail.com>


Anyone have a script to read a DDL file and build indexes using parallel worker processes? Something in perl or shell would be preferable. I am trying to work around data pump's slow "feature" of building indexes with one query coordinator by extracting the metadata ddl and running them with real parallelization. I was just getting started with a perl script using fork but wanted to check here so as not to reinvent the wheel.

--

Charles Schultz

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 18 2007 - 15:43:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US