Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Database + Options
This discussion is archived
on Dec 18, 2012 1:39 PM by 758358
Reorganizing or shrinking Oracle Queeus Online
Dec 18, 2012 11:05 AM
I want to reorganizing a Oracle QUEUE table. When I tried to re-org this table I am getting many locking blocking issues as this queue is runnign 24/7 basis. and getting this error
ERROR at line 1:
ORA-42008: error occurred while instantiating the redefinition
ORA-12034: materialized view log on
"ADMIN"."AQ$_CUSTOMQUEUE_H" younger than last refresh
then I tried shrinking the space and getting this error
ERROR at line 1:
ORA-10636: ROW MOVEMENT is not enabled
Question 1>> What would be the impact on performace if we would keep row movement enabled for the tables permanently.
Question 2>> Instead of rebuilding the indexes post table shrink can we use cascade option with table shrink space itself.
e.g. alter table admin.CUSTOMQUEUE shrink space cascade;
what would be the difference if we use cascade option?
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: Reorganizing or shrinking Oracle Queeus Online
Dec 18, 2012 1:39 PM
in response to
did you review: How do I reduce the High Watermark (HWM) of Advanced Queueing objects? [ID 421474.1] on MOS?