IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial

Tag Archives: rebuild index oracle

Alter Index Rebuild Online in Oracle

Mehmet Salih Deveci June 16, 2021 Oracle 0

I will explain Alter Index Rebuild Online in Oracle in this post.

ORA-01502 index or partition of such index is in unusable state | Rebuild & Drop Index

Mehmet Salih Deveci September 18, 2020 ORA-ERRORS 0

I got ” ORA-01502 index or partition of such index is in usable state ” error in Oracle database.

Index Maintenance and Index Operations in Oracle Database

Mehmet Salih Deveci June 27, 2019 Oracle, Performance Tuning 0

I will explain Index Maintenance and Index Operations in Oracle Database in this article.

Real Life Index Usage and Index Performance Test in Oracle Database

Mehmet Salih Deveci June 27, 2019 Oracle, Performance Tuning 1

Hi, I will explain Real Life Index Usage and Index Performance Test in Oracle Database in this article.

Index Types and Index Create in Oracle Database

Mehmet Salih Deveci June 27, 2019 Oracle, Performance Tuning 0

I will explain Index Types and Index Create in Oracle Database in this article.

What is an Index ( Advantages and Disadvantages ) in Oracle Database

Mehmet Salih Deveci June 27, 2019 Oracle, Performance Tuning 4

I will Explain What is an Index ( Advantages and Disadvantages ) in Oracle Database in this Article.

How to Rebuild Unused Indexes or Move Another Tablespace in Oracle

Mehmet Salih Deveci April 6, 2019 Oracle, Oracle DBA Scripts 0

Hi, Sometimes you need moving tables and indexes to the new tablespace in Oracle.