alter index abc rebuild online;

11g new feature : index rebuild online.

In Oracle Database 11g, the online rebuild is truly online: it does not hold an exclusive lock. The DMLs are not affected.  It does so by tracking which blocks are being accessed and at the end merging these blocks with the newly built index.

Comments

Post a Comment

Popular posts from this blog

OCM 11g -Finally complete

Hello everybody.... Many thanks to god....... finally my OCM exam result is out and I got a mail ..and I have successfully cleared the Oracle Certified Master exam and I have been awarded OCM status by Oracle Corp.....It was the most awaited email which i got couple of hours back................Cheers !!!
Read more

First Step : Oracle DBA

First Step towards Oracle DBA: My thoughts: I think a learner DBA should not jump on the Oracle database,sql,plsql to start with. It will be really nice to understand the basics of RDBMS: (May be learnig in parallel, But donot avoid Learning database design concpets) To learn DBA from very basics you must understand the database design. Learn RDBMS concepts. Learn Normalization Relations Between Tables Best Practices in Database Design Try to Create Few tables based on some data, Normalization is an important step in database design, as it minimizes the redundancy in information. If required level of Normalization is not achieved , It will not be a good database design. If redundancy is not eliminated then more space is required to store the data. Which is not a good database design. You can google normalization and you will get lot of pages so i am not describing here. You can read from the website http://www.dbnormalization.com/ The key here is that you sh...
Read more

List of Third party softwares for Oracle applications. (third party bolt-ons to Apps)

I have compiled a list of commonly use (Obviously -not all) 3rd party softwares with Oracle applications. These products extend the capabilities of Oracle applications. as an Oracle Apps DBA you may need to work with these software vendors and Sometime you may also need to configure these softwares with Oracle applications. Fortunately i have worked on all of these in the past. 1. AventX The AventX Oracle Connector (hereafter referred to as AventX Connector) provides the capability to deliver reports via fax, email or printer. AventX Connector processes documents from Oracle E-business suite (hereafter referred to as Oracle Applications or OA) and submits them to the document delivery system for delivery AventX Connector uses a set of tables in the Oracle database to store site-specific configuration options and document delivery information. In addition, AventX Connector requires the compilation, installation, and registration of customized forms and library files. http://www....
Read more