Loading....

BEGIN
sys.dbms_scheduler.create_job(
job_name => ‘”HR”.”ALTER_INDX001″‘,
job_type => ‘PLSQL_BLOCK’,
job_action => ‘begin
EXECUTE IMMEDIATE ”alter index HR.EMP_NAME_IX coalesce”;
end;’,
start_date => systimestamp at time zone ‘Asia/Muscat’,
job_class => ‘DEFAULT_JOB_CLASS’,
comments => ‘This job will coalesce index HR.EMP_NAME_IX on the EMPLOYEES table’,
auto_drop => FALSE,
enabled => FALSE);
sys.dbms_scheduler.set_attribute( name => ‘”HR”.”ALTER_INDX001″‘, attribute => ‘restartable’, value => TRUE);
sys.dbms_scheduler.enable( ‘”HR”.”ALTER_INDX001″‘ );
END;

Please follow and like us:

Last Update: June 18, 2009  

June 18, 2009 240 Gavin Soorma
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?