ORA-12991: Column Is Referenced In A Multi-Column Constraint

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 1. Check whether the column is part of Multi-column constraint or not. SQL>  select COLUMN_NAME,CONSTRAINT_NAME,POSITION from dba_cons_columns where table_name=‘EMPLIST’; COLUMN_NAME   CONSTRAINT_NAME   POSITION ——————– […]

Read More

ORA-19809: Limit Exceeded For Recovery Files

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 RECID=1751 […]

Read More

ORA-01624: Log 1 Needed For Crash Recovery Of Instance

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 […]

Read More

RMAN-08137: WARNING: Archived Log Not Deleted, Needed For Standby

We are going to learn steps which we use to solve the issues while we receive error RMAN-08137. we have mention about the problem and cause why does it occurs ,after the problem and cause we have solution in his post. PROBLEM: Archive logs are not getting deleted with RMAN command, and it is reporting below […]

Read More

ORA-01466: Unable To Read Data – Table Definition Has Changed During Flashback

PROBLEM: While doing flashback a table to a prior timestamp, got below error. 11:20:45 SQL> FLASHBACK TABLE test2 TO TIMESTAMP TO_TIMESTAMP(‘2017-07-12 11:18:55’, ‘YYYY-MM-DD HH24:MI:SS’); FLASHBACK TABLE test2 TO TIMESTAMP TO_TIMESTAMP(‘2017-07-12 11:18:55’, ‘YYYY-MM-DD HH24:MI:SS’) * ERROR at line 1: ORA-01466: unable to read data – table definition has changed CAUSE & SOLUTION: This error happens when […]

Read More

ORA-30032: The Suspended (Resumable) Statement Has Timed Out

PROBLEM: While doing a transaction, it was hung for few seconds and got the below error. SQL> create TABLE TEST_3 as select * from dba_objects; create TABLE TEST_3 as select * from dba_objects * ERROR at line 1: ORA-30032: the suspended (resumable) statement has timed out   CAUSE & SOLUTION: Let’s check the alert log: […]

Read More

ORA-30033: Undo Tablespace Cannot Be Specified As Default User Tablespace

PROBLEM: While creating or altering a user with default tablespace got below error. SQL> alter user dba_raj default tablespace UNDOTBS1; alter user dba_raj default tablespace UNDOTBS1 * ERROR at line 1: ORA-30033: Undo tablespace cannot be specified as default user tablespace SQL> create user TEST_USER identified by TEST_user default tablespace UNDOTBS1; create user TEST_USER identified […]

Read More

ORA-28040: No Matching Authentication Protocol

We are going to learn about the steps which help to solve ORA-28040 issue. No Matching Authentication Protocol. First, we must know about  Authentication Protocol. First few lines explain about the technical definition of  Authentication Protocol. After completing definition we have steps to solve this issue. An authentication protocol is a type of computer communications protocol or cryptographic […]

Read More

ORA-02020: Too Many Database Links In Use

PROBLEM: While querying against a database link, got below error. select sysdate from dual@DB5 * ERROR at line 1: ORA-02020: too many database links in use CAUSE & SOLUTION: open_links parameter control, the number of database links each session can use without closing it. If you access a database link in a session, then the link […]

Read More

ORA-20002: Version Of Statistics Table SCOTT.STATS Is Too Old

Being DBA we may face this error in many phase example while upgrading we face error while transferring stats from 10g to 11g, While importing a stats table in Oracle 12c, for which the stats export was done from 11g. We are focusing on this error.  While importing a stats table in Oracle 12c, for which […]

Read More