Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

Re: script to drop/create schema indexes

Prem Khanna J

2007-07-27

Replies:

Yes Goran .

SQL> select dbms_metadata.get_ddl ('INDEX',<username>) from user_indexes ;

This will give me all the DDLs. I have it already . I am looking for a complete shell/SQL
script which can do the do the drop/create in parallel (spin off several processes) ,
handle errors if any .One like that.

That would save lot of time for me. I should have told this in my original post.
If someone has that already & can share it with me , it would be great .

~jp~

On 7/27/07, goran bogdanovic <goran00@gmail.com> wrote:
you may use dbms_metadata package to get ddl for indexes in question...

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.