Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail From: sybrandb@yahoo.com Newsgroups: comp.databases.oracle.misc Subject: Re: 'Alter index rename subpartition' on table with not commited data (from other session) Date: 6 Jun 2005 04:55:52 -0700 Organization: http://groups.google.com Lines: 28 Message-ID: <1118058952.255429.295110@z14g2000cwz.googlegroups.com> References: NNTP-Posting-Host: 144.44.150.152 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1118058957 14500 127.0.0.1 (6 Jun 2005 11:55:57 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 6 Jun 2005 11:55:57 +0000 (UTC) In-Reply-To: User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: z14g2000cwz.googlegroups.com; posting-host=144.44.150.152; posting-account=3-ZCkwwAAAAif1uTJMVWCyzt_MY2v5ol Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:119645 Wojciech Klapyta wrote: > Hi everybody! > > ALTER INDEX foo RENAME SUBPARTITION bar1 TO bar2; when foo is a bitmap > index results in an ORA-0054 error "Resource busy with NOWAIT specified" > when the table this index belongs to, contains uncommitted data (created > in another session) - even if the data are not in bar1 subpartition of > the table. > > Does anybody konw if: > > 1) the whole foo index is read/rebuild during ALTER INDEX foo RENAME > SUBPARTITION bar1 TO bar2; ? > 2) is there a workaround for ORA - 0054 exception in this case? > > Thanks in advance for your help, 1) Likely not. But that is not your problem. Your problem is you have a parse lock on the affected object. 2) Yes. Kick out the other users. -- Sybrand Bakker Senior Oracle DBA