Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Optimization of all indexes?

755744Apr 1 2010 — edited Apr 1 2010
Hello,

I know that an "alter index X coalesce" optimizes the index X. But I want to optimize all indexes of a database but I don't want to write a script with some hundred alter index statements? Is there a smart way to do this like:

for i in indexes loop
alter index i coalesce;
commit;
end loop;

(Pseudocode)

Edited by: user9206958 on 01.04.2010 01:30

Comments

User_YWIZ9

Dead forum?

justsomeone

Hello @user-ywiz9

to see full sample go to https://javaee.github.io/javamail/#Samples
also you can check this one https://www.courier.com/guides/java-send-email/
or this one https://www.javatpoint.com/example-of-sending-email-using-java-mail-api

hope those help and have a nice day :)

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 29 2010
Added on Apr 1 2010
#general-database-discussions, #index
6 comments
496 views