” ORA-08104: this index object 4357688 is being online built or rebuilt ” error in index Rebuild. Details of error are as follows. SQL> ALTER INDEX MSDBA.TEST_INDEX REBUILD TABLESPACE MYTBS [...]

           A database link allows you to reference objects in a remote database. Typically, the remote database will be another Oracle database, but it can be any ODBC compliant database.When [...]

  Details of error are as follows. ALTER INDEX MSDBA.TEST_INDEX DISABLE Error at line 1 ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option ORA-02243: invalid ALTER INDEX or [...]

Let’s take the employees database, and slightly modify the employees tables:       mysql> ALTER TABLE employees ADD INDEX idx_first (first_name),ENGINE=InnoDB;   1 SELECT * [...]

I will explain How to Add Disks to ASM Disk Group in Oracle with ALTER DISKGROUP DATA ADD DISK Command in this post. You can add disks to ASM Disk group as follows. In this Example my Disk group [...]

I will explain How to Use TABLE_EXISTS_ACTION During IMPDP in Oracle Datapump in this post. Table_exists_action: While Import process is running if any table exists in database what will Oracle [...]

To manage Oracle database’s storage, Oracle recommends The Automatic Storage Management (ASM) to be used regardless of database’s configuration: single-instance Oracle Database or Oracle Real [...]

I will explain How to Use CONTENT ( DATA_ONLY , METADATA_ONLY ) Parameter in Oracle Datapump   CONTENT: This parameter enables you to filter what is export and import during the export – [...]

Flashback must be turned on in order to be able to use Guaranteed Restore Point. To enable Flashback, we need to use the FRA parameter like following. SQL> show parameter db_recovery_file NAME [...]

Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other [...]