” 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…
Read MoreA database link allows you to reference objects in a remote database. Typically, the remote database will be another Oracle database, but it can be…
Read MoreDetails 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 ALTER MATERIALIZED…
Read MoreLet’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 * FROM employees ORDER BY…
Read MoreI 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…
Read MoreI 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 do…
Read MoreTo 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 Application Clusters configurations. It is…
Read MoreI 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…
Read MoreFlashback 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…
Read MoreCause: 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…
Read More