Home » Article » Rebuild Index di Oracle 11g (rebuild online compress)

Rebuild Index di Oracle 11g (rebuild online compress)

Pages

October 2011
M T W T F S S
« Sep   Nov »
 12
3456789
10111213141516
17181920212223
24252627282930
31  

RSS Link

  • An error has occurred; the feed is probably down. Try again later.

Twitter Updates

Blog Stats

  • 345,611 hits

Archives

Pengunjung


Setelah kasus ORA-01502 yang menyebabkan beberapa index tidak bisa diakses oleh user, maka dilakukan search index-index lain yang mengalami state serupa, yaitu UNUSABLE. Setelah didapatkan beberapa index, dilakukanlah rebuild index secara online dan sekaligus melakukan index compression.

Untuk melakukannya, gw langsung lewat sqlplus dan ajaibnya cara ini lebih cepat daripada menggunakan tools dari SAP (BRTOOLS). Bahkan kecepatannya bisa mencapai 2-3 kali lebih cepat.

Berikut script yang gw bikin untuk bisa melakukan rebuild index sekaligus kompresi.

sqlplus ‘/as sysdba’
spool /oracle/WPR/index_rebuild_log.txt
alter index SAPWPR.”ACCTIT~Z01″ rebuild online compress;
alter index SAPWPR.”S514~VAB” rebuild online compress;
alter index SAPWPR.”TCJ_POSITIONS~0″ rebuild online compress;
alter index SAPWPR.”S055~VAB” rebuild online compress;
alter index SAPWPR.”S055~0″ rebuild online compress;
alter index SAPWPR.”GLPCA~7″ rebuild online compress;
alter index SAPWPR.”GLPCA~3″ rebuild online compress;
alter index SAPWPR.”GLPCA~2″ rebuild online compress;
alter index SAPWPR.”FMEP~W” rebuild online compress;
alter index SAPWPR.”FMEP~V” rebuild online compress;
alter index SAPWPR.”FMEP~R” rebuild online compress;
alter index SAPWPR.”FMEP~M” rebuild online compress;
alter index SAPWPR.”FMEP~K” rebuild online compress;
alter index SAPWPR.”ACCTIT~1″ rebuild online compress;
alter index SAPWPR.”ACCTIT~0″ rebuild online compress;
spool off
exit

File diatas disimpan sebagai file sql (rebuild_index.sql) dan bisa dipanggil dari sqlplus.

Selamat mencoba !!


1 Comment

  1. SAP OS DB MIGRATION ONLINE TRAINING complete Support for a Migration of your

    Operating System and Database Description ,If at any stage of the SAP software

    life cycle you should need to change your operating system and/or database,

    the SAP OS DB MIGRATION ONLINE TRAINING Check optimally prepares you for a

    successful migration and supports smooth continued operations on the new

    platform.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: