If ORA-08104 error (ORA-08104: this index object < -- > is being online built or rebuilt)
declare
isclean boolean;
begin
isclean := false;
while isclean = false
loop
isclean := DBMS_REPAIR.ONLINE_INDEX_CLEAN
(dbms_repair.all_index_id, dbms_repair.lock_wait);
dbms_lock.sleep (10);
end loop;
end;
/
Random Posts
Blog Archive
ORACLE DBA
Search This Blog
Blog Archive
-
▼
2015
(41)
-
▼
July
(10)
- Automated Database Maintenance Task Management
- ORA-08104 error - ONLINE_INDEX_CLEAN
- Remote Diagnostic Agent (RDA)
- Archive generation rate
- Blocking sessions and Locks
- Steps to run the tuning adviser manually
- AGENT HOME TROUBLE SHOOTING
- AWR report generation script for multiple snap ids
- How to Configure and use Flashback Database
- Using Normal and Guaranteed Restore Points
-
▼
July
(10)
Thirupal Boreddy. Powered by Blogger.
My Blog List
Followers
Lorem 1
Technology
Circle Gallery
‹
›
Shooting
Racing
News
Lorem 4
Home
»
»Unlabelled
» ORA-08104 error - ONLINE_INDEX_CLEAN
Tagged with:
About Oracle DBA World
WePress Theme is officially developed by Templatezy Team. We published High quality Blogger Templates with Awesome Design for blogspot lovers.The very first Blogger Templates Company where you will find Responsive Design Templates.
Subscribe to:
Post Comments (Atom)
QUERY FOR CPU USAGE
select a.target_name as HOST, to_char(a.rollup_timestamp,' dd-Mon-yy::hh24:mi') as "DAY-TIME", sum(c.cpu_count) as ...
No comments