Today I tried to create an INDEX over 2 columns where one of them were already indexed. After receiving the error ORA-00054 - resource busy and acquire with NOWAIT I needed some time that this is because of previous used INDEX.
Previously used index:
CREATE INDEX index_name ON table_name
(
column_name ASC
)
/
wanted to change it to the following:
CREATE INDEX index_name ON table_name
(
column_name1,column_name2
)
/
all I needed to do were to delete previous INDEX and then it run fine - maybe this is not at any scenario correctly to do but for my case it worked out.
Monday, July 07, 2008
Oracle Error: ORA-00054 - resource busy and acquire with NOWAIT
Subscribe to:
Post Comments (Atom)
Shared Cache - .Net Caching made easy
All information about Shared Cache is available here: http://www.sharedcache.com/. Its free and easy to use, we provide all sources at codeplex.
No comments:
Post a Comment