Script to build indexes in parallel

  • From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 18 Dec 2007 15:43:52 -0600

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

Other related posts: