ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

Is it possible to rebuild index of oracle 11g table while keeping the application running and access/update the table?

The purpose is not to shutdown the application while index is rebuilt. The application is24/7 or online transaction type.

user-image
تم إضافة السؤال من قبل Zahidul Alam Chowdhury , Business Assurance Senior Assistant Manager , Banglalink Digital Communications Ltd.
تاريخ النشر: 2013/10/04
Jad Al-Quraan
من قبل Jad Al-Quraan , Head of department : analysis and systems development & Oracle DBA , Tafila Technical University

yes you can rebuild index online 

It will affect only the efficiency during the implementation process

After that everything returns to normal

Rajesh Mullavalappil
من قبل Rajesh Mullavalappil , Senior Database Administrator , ERES- Dubai Land Department

yes, rebuild the index online.

Mobeen Ahmed
من قبل Mobeen Ahmed , Systems Specialist - Cloud Technologies , Alghanim Industries

alter index <index_name> rebuild online;  is the query to rebuild indexes while users are accessing data in table.

Nawaf  Naji
من قبل Nawaf Naji , Business Development Manager , Bonnon Coffee

Yes you could do that rebuild the index online and everything will be normal in the process if you have oracle background.

Dhairyasheel Tawade
من قبل Dhairyasheel Tawade , Principal Technical Account Manager , Oracle India

When you use an online index rebuild Oracle has to create a log of all changes you make to the table while the rebuild is running. Once the log is set up, Oracle creates a new index using a read-consistent copy of the data in the table, then copies the logged changes into this index, and finishes off by tidying up the data dictionary, dropping temporary segments, and dropping the log.

 

http://jonathanlewis.wordpress.com/2009/06/05/online-rebuild/

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟