Skip to Main Content

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!

Is renaming an index an online operation?

DoevelaarFeb 26 2014 — edited Feb 28 2014

Hello all,

I need to rename an index on a busy and large table and I was wondering if this would be an online operation: can users coninue work when I'm doing this? I can't find the answer in the docs.

Kind regards.

This post has been answered by Hemant K Chitale on Feb 26 2014
Jump to Answer

Comments

archie172
On second thought, this really seems like a functional bug rather than a documentation bug. Why shouldn't SecondaryCursor.dup(false) succeed when the cursor is not initialized?
archie172
Patch to fix.... ?
--- bdb/com/sleepycat/je/SecondaryCursor.java   2008-06-10 10:52:08.000000000 -0500
+++ src/java/com/sleepycat/je/SecondaryCursor.java      2009-02-24 12:11:56.531382458 -0600
@@ -117,7 +117,7 @@
     public Cursor dup(boolean samePosition)
         throws DatabaseException {

-        checkState(true);
+        checkState(false);
         return new SecondaryCursor(this, samePosition);
     }
Edited by: archie172 on Feb 24, 2009 10:53 AM (added better code formatting)
524761
archie172 wrote:

P.S. when is this forum going to add a pre-formatted (fixed-width) text option?
You mean like this?
diff -r 671c95c08dd4 src/com/sleepycat/je/SecondaryCursor.java
--- a/src/com/sleepycat/je/SecondaryCursor.java
+++ b/src/com/sleepycat/je/SecondaryCursor.java
@@ -117,7 +117,7 @@
     public Cursor dup(boolean samePosition)
         throws DatabaseException {
 
-        checkState(true);
+        checkState(false);
         return new SecondaryCursor(this, samePosition);
     }
 
Please see the forum FAQ.
Greybird-Oracle
Answer
Archie,

Yes and yes -- this is a bug and that is the correct fix.

Thanks!! We'll fix this in the next patch release.

--mark
Marked as Answer by archie172 · Sep 27 2020
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 28 2014
Added on Feb 26 2014
14 comments
966 views