Home » SQL & PL/SQL » SQL & PL/SQL » Question for PL/SQL Package dbms_repair
Question for PL/SQL Package dbms_repair [message #209317] Thu, 14 December 2006 04:42 Go to next message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Hi all,

I just have a problem to handel the dbms_repair.online_index_clean in an Oracle 9.2.0.6 Database.
We have an Index which shows that its stil in build/rebuild phase after the prcess was skipped by firewall-rules yesterday evening.
Oracle suggested to use dbms_repair.online_index_clean
I tried this but it brought out that :

ERROR at line 1:
ORA-06550: line 1, column 19:
PLS-00302: component 'ONLINE_INDEX_CLEAN' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Do I have to install a special package ?
Whioch syntax I do need to use for this package to clean. I have only the number of the unsuable index, which is shown as VALID ind user_indexes and dba_indexes.

regards
Uwe
Re: Question for PL/SQL Package dbms_repair [message #209322 is a reply to message #209317] Thu, 14 December 2006 04:53 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
From which schema you are executing the above?
Try desc dbms_repair and check whether you have granted the privileges on the procedure or not.

For syntax check this.
DBMS_REPAIR
By
Vamsi
Re: Question for PL/SQL Package dbms_repair [message #209323 is a reply to message #209322] Thu, 14 December 2006 05:04 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

The package is owned by SYS. Execution privilege is not granted to other users.
Re: Question for PL/SQL Package dbms_repair [message #209333 is a reply to message #209323] Thu, 14 December 2006 06:08 Go to previous messageGo to next message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Thanks,
but first I am working as SYS¨
and second is that Oracle mentioned that this packge part ONLINE_INDEX_CLEAN should be from 9.2.0.6 and above, but this feature is not installed with the scripts from $ORACLE_HOME/rdbms/admin.
The function i need seems to be included in later Versions.

Finally the index was dropable, I guess it was in a heavy rollback-phase.

regards
Uwe
Re: Question for PL/SQL Package dbms_repair [message #209341 is a reply to message #209333] Thu, 14 December 2006 06:47 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If it was Oracle that advised you to run this, why don't you ask THEM how to run it?
Sounds to me that this should be part of there advice.
Re: Question for PL/SQL Package dbms_repair [message #209343 is a reply to message #209341] Thu, 14 December 2006 06:58 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Well if you look in {ORACLE_HOME}/rdbms/admin/dbmsrpr.sql

You can verify it for sure..
Previous Topic: Invalid Record Count in Oracle query while using dblink
Next Topic: send values to IN query with parameter
Goto Forum:
  


Current Time: Sat Dec 10 03:05:47 CST 2016

Total time taken to generate the page: 0.05115 seconds