OraFAQ Forum: Server Administration » Ramifications of ORA-01555 on Oracle Text index

Home » RDBMS Server » Server Administration » Ramifications of ORA-01555 on Oracle Text index (9i, Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Ramifications of ORA-01555 on Oracle Text index [message #394541]

Fri, 27 March 2009 13:25

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

Report message to a moderator

Re: Ramifications of ORA-01555 on Oracle Text index [message #394544 is a reply to message #394541]

Fri, 27 March 2009 13:32

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Ramifications of ORA-01555 on Oracle Text index [message #394547 is a reply to message #394541]

Fri, 27 March 2009 13:52

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

Report message to a moderator

Re: Ramifications of ORA-01555 on Oracle Text index [message #394550 is a reply to message #394541]

Fri, 27 March 2009 14:19

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Ramifications of ORA-01555 on Oracle Text index [message #395240 is a reply to message #394541]

Tue, 31 March 2009 19:57

Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA

Senior Member

http://forums.oracle.com/forums/thread.jspa?messageID=1894184&#1894184

Report message to a moderator

Previous Topic:	AIX random IO error
Next Topic:	Table reached maxextents

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 20:14:05 CST 2024