-
How I can get the script for all the Indexes in the Database.I need to create the same Indexes in another database with totally identical objects.I have Oracle7.3.4 Database.
Thanks
Ravi
-
you'll have to generate it from user_ind_columns ...
and be careful since PK indexes are constraints ...
-
1. do a full export with rows=n (exp system/manager file=xyz.dmp full=y rows=n)
2. import with indexfile=xyz.sql (imp system/manager file=xyz.dmp indexfile=xyz.sql)
3. your indexes are now defined in xyz.sql
Jeff Hunter
-
Is there any tool available to do this.
-
EZSQL, TOAD, SQL Navigator, Precise SQL...
EZSQL is the best one though. And it costs less than
all of the others. http://www.ezsql.net
the exp/imp method is really very easy though.
-John
-
-
Hell yeah!
send me an email - john@ezsql.net
-
Originally posted by chrisrlong
PS - so, if I give you a plug in my book, can I get a 'free' copy?
So, if we plug your book, do we get a free copy? No wait, that won't work. Can we get a free copy of your book so we can plug it?
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|