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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

corrupted indexes

ski123Sep 9 2009 — edited Jun 16 2010
Oracle 9.2. We have a job running slow suddenly. Normal run time is 2 hours, now it is 6 hours. The data volume is the same. we are wondering if the indexes is corrupted. How to find corrupted indexes?
Thanks

S.

Comments

aJohny

Inside you loop you could get the file name using

textfiles.getName();

You could filter with the file extension.

Cheers

AJ

2801625

Can you explain what you mean by filter with the file extension.

aJohny
Answer

You have mentioned you want to read only text files.

If you are referring to some specific set of extentions, you can filter based on that.

ex: you want to read only .txt files, you can add an if condition as below :

          if(textfiles.getName().endsWith(".txt")) {


              // Add your code here


          }

Cheers

AJ

Marked as Answer by 2801625 · Sep 27 2020
2801625

I was able to read only the text files in the directory checking the extension using textfiles.getname and textfiles.endswith.

Thanks for the help AJ.

     for (File textfiles : files) {

     if (textfiles.isFile() && textfiles.getName().endsWith("txt")) {

1 person found this helpful
aJohny

If all good, Please close the thread by marking the helpful and correct answers.

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

Post Details

Locked on Dec 25 2009
Added on Sep 9 2009
#general-database-discussions
92 comments
23,034 views