Oracle Database Discussions

Hi buddies,

Good evening.

I have a sql scipt (which is created from indexfile) like:

alter table A add constrait xx;
alter table A add constarit xxx;
alter table A add constarit xxx;
alter table B add constarit xxx;
alter table B add constarit xxx;
......
.(hundreds of them).....


I will parallelly run against this sql scipt by using a shell scipt.

but I need to shuffle the above scipt first, or, I will see the lock problem because they run parallelly against one table (it happens)

so do you know how to shuffle this scipts (ramdomize it) evenly? --this is very insteresting.

THanks a lot in advance.

Jerry

Edited by: jerrygreat on Nov 18, 2008 3:34 PM