PROBLEM: While creating a table using CTAS, got below error: SQL> create table test as select * from DBACLASS.CREDIT_CARD_INFO; create table test as select * from DBACLASS.CREDIT_CARD_INFO * ERROR at line 1: ORA-28081: Insufficient privileges – the command references a redacted object. CAUSE & SOLUTION The error indicates, that the objects which we are trying […]

PROBLEM: While dropping a redolog group, got below error. SQL> alter database drop logfile group 3; alter database drop logfile group 3 * ERROR at line 1: ORA-01623: log 3 is current log for instance SBIP18DB (thread 1) – cannot drop ORA-00312: online log 3 thread 1: ‘/SIBIP16/SBIP18DB/SBIP18DB/redo03.log’ SOLUTION: First, check the status of the […]

PROBLEM: While dropping a redolog group , got below error. SQL> alter database drop logfile group 1; alter database drop logfile group 1 * ERROR at line 1: ORA-01624: log 1 needed for crash recovery of instance SBIP18DB (thread 1) ORA-00312: online log 1 thread 1: ‘/SIBIP16/SBIP18DB/SBIP18DB/redo01.log’ SOLUTION: First get the status of redolog group: […]

PROBLEM: While trying to recreating a controlfile in RAC database, got below error. ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-12720: operation requires database is in EXCLUSIVE mode SOLUTION: Before recreating controlfile in RAC database, we need to set the cluster_database parameter to FALSE. SQL> show parameter cluster_database NAME TYPE VALUE ———————————— ———– ———————– […]

PROBLEM: While trying to create a table using CTAS , got below error:(ORA-00997) create table test8 AS select DIRECTIONS from siebel.s_org_ext; create table test8 AS select DIRECTIONS from siebel.s_org_ext * ERROR at line 1: ORA-00997: illegal use of LONG datatype SOLUTION: In general, we can’t create an object_type OF LONG datatype using CTAS method. desc […]

PROBLEM: While taking rman backup, it failed with below error ( ORA-19809 & ORA-19804) RMAN> backup archivelog all; Starting backup at 26-MAY-17 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=1942 RECID=1750 STAMP=944758808 input archived log thread=1 sequence=1943 […]

PROBLEM: While dropping a column, got the below error. SQL> ALTER TABLE dbaclass.EMPLIST DROP (empname); ALTER TABLE dbaclass.EMPLIST DROP (empname) * ERROR at line 1: ORA-12991: column is referenced in a multi-column constraint SOLUTION: If the column is part of a multi-column constraint, then we have to drop all the columns of that constraint. Dropping […]

PROBLEM: While dropping a column , got below error. SQL> alter table dbaclass.test89 drop (OWNER,OBJECT_NAME); alter table dbaclass.test89 drop (OWNER,OBJECT_NAME) * ERROR at line 1: ORA-12985: tablespace ‘USERS’ is read only, cannot drop column SOLUTION: The object which is trying to drop belongs to a tablespace is in read only mode. 1. Find the tablespace […]

PROBLEM: While dropping a column on the table, got the below error.(ORA-12984) SQL> alter table dbatest.ORDER_TAB drop (CREATED); alter table dbatest.ORDER_TAB drop (CREATED) * ERROR at line 1: ORA-12984: cannot drop partitioning column REASON: oerr ora 12984 12984, 00000, “cannot drop partitioning column” // *Cause: An attempt was made to drop a column used as […]

PROBLEM: While trying to drop a column from a table, owned by SYS, got below error.(ORA-12988) SQL> show user USER is “SYS” SQL> alter table test3 drop ( CREATED); alter table test3 drop ( CREATED) * ERROR at line 1: ORA-12988: cannot drop column from table owned by SYS SOLUTION: oerr ora 12988 12988, 00000, […]