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-12985: Tablespace ‘USERS’ Is Read Only, Cannot Drop Column

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

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

ORA-01623: Log 3 Is Current Log For Instance Cannot Drop

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

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-39095: Dump File Space Has Been Exhausted: Unable To Allocate

PROBLEM: While running expdp with filesize parameter, got below error.   expdp dumpfile=full1.dmp logfile=full1.log directory=T filesize=100m full=y Starting “SYS”.”SYS_EXPORT_FULL_01″: /******** AS SYSDBA dumpfile=full1.dmp logfile=full1.log directory=T filesize=1m full=y Estimate in progress using BLOCKS method… Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA Total estimation using BLOCKS method: 251.0 […]

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-14404: Partitioned Table Contains Partitions In A Different Tablespace

PROBLEM: While dropping a tablespace, got error ORA-14404. SQL> drop tablespace TEST_2 including contents and datafiles; drop tablespace TEST_2 including contents and datafiles * ERROR at line 1: ORA-14404: partitioned table contains partitions in a different tablespace CAUSE & SOLUTION: This error occurs when we try to drop a tablespace, which contains tables, whose partitions/subpartitions are […]

Read More