Home » RDBMS Server » Server Administration » Ramifications of ORA-01555 on Oracle Text index (9i, Unix)
Ramifications of ORA-01555 on Oracle Text index [message #394541] Fri, 27 March 2009 13:25 Go to next message
nibeck
Messages: 3
Registered: March 2009
Junior Member
Not a DBA, but trying to gather information relating to recent production issue.

We were implementing Oracle Text for some advanced searching capabilities in our application. While generating the Oracle text index on our table, we got the dreaded ORA-01555. Until that "corrupt" text index was dropped, it appears that update activity against the table we were creating the index on were failing.

I just want to verify that this is indeed what would happen, and that once the index were dropped, the base table would continue to function, but the Oracle Text index would not be there, so text searching would not function.

I'm also assuming that this condition would be true for any type of index creation on a table, not just Oracle Text.

_mike
Re: Ramifications of ORA-01555 on Oracle Text index [message #394544 is a reply to message #394541] Fri, 27 March 2009 13:32 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
visit http://asktom.oracle.com & do keyword search on ORA-01555

This error occurs when there is a long running query
and 1 or more other sessions are doing DML against same table.

The DML succeeds; while the SELECT errors out.
Re: Ramifications of ORA-01555 on Oracle Text index [message #394547 is a reply to message #394541] Fri, 27 March 2009 13:52 Go to previous messageGo to next message
nibeck
Messages: 3
Registered: March 2009
Junior Member
Thanks for the quick reply. I understand (at least partially) why/how it can happen, I'm more interested in what would happen to other DML running against that table with the now corupt index? Would they hang?, would they rollback?

_mike
Re: Ramifications of ORA-01555 on Oracle Text index [message #394550 is a reply to message #394541] Fri, 27 March 2009 14:19 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I'm more interested in what would happen to other DML running against that table with the now corupt index?
They succeed.

>Would they hang?,
NO

>would they rollback?
no
Re: Ramifications of ORA-01555 on Oracle Text index [message #395240 is a reply to message #394541] Tue, 31 March 2009 19:57 Go to previous message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
http://forums.oracle.com/forums/thread.jspa?messageID=1894184&#1894184
Previous Topic: AIX random IO error
Next Topic: Table reached maxextents
Goto Forum:
  


Current Time: Sat Dec 10 22:34:21 CST 2016

Total time taken to generate the page: 0.06103 seconds