While inserting data to a partitioned table, got below error. SQL> insert into RANGE_TAB values(to_date(‘24032016′,’ddmmyyyy’),100); insert into RANGE_TAB values(to_d...
ORA-
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
While creating unique index on a table , got below error. SQL> create unique index TEST_IDX on TEST5(EMPNO); create unique index TEST_IDX on TEST5(EMPNO) * ERROR at line 1: ORA-01452: cannot CREAT...
ORA-25152: TEMPFILE cannot be dropped at this time
PROBLEM: While dropping a tempfile got the below error. SQL> alter tablespace TEMP drop tempfile ‘/archive/NONPLUG/NONCDB/temp01.dbf’; alter tablespace TEMP drop tempfile ‘/archi...
ORA-15235: diskgroup mount mode conflicts with existing mount
PROBLEM: While mounting a diskgroup in restrict mode, got below error: SQL> alter diskgroup NEWTST mount restricted; alter diskgroup NEWTST mount restricted * ERROR at line 1: ORA-15032: n...
ORA-15027: active use of diskgroup precludes its dismount
While dismounting a diskgroup, got the below error: SQL> alter diskgroup NEWTST dismount; alter diskgroup NEWTST dismount * ERROR at line 1: ORA-15032: not all alterations perform...
ORA-02266: unique/primary keys in table referenced while truncating table
While truncating a table in database, might face the error ORA-02266 unique key error. PROBLEM: SQL> truncate table DBACLASS.AAF_USER; truncate table DBACLASS.AAF_USER * ERROR at line 1: ORA...
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
We have recently upgraded our database from 11g to 12c. And when one of the developer ran some job, the job got killed and got the below error in log. These jobs were running fi...
ORA-24247: network access denied by access control list (ACL)
While sending mail using utl_mail or utl_stmp in oracle 11g, you may get access denied error: begin utl_mail.send(sender => ‘admin@dbaclass.com’, recipients => ̵...
ORA-01450: maximum key length (6398) exceeded
While creating a composite index in the oracle database, got SQL> create index EMP_TAB_IDX1 on EMP_TAB ( EMPNAME,LOCATION,DEPT); create index EMP_TAB_IDX1 on EMP_TAB ( EMPNAME,LOCATION,DEPT) *...
ORA-56935: existing datapump jobs are using a different version
While importing in an oracle 12c database, got below error: ERROR: impdp dumpfile=teset2.dmp logfile=imp_teset2.lod directory=ODSFINAL remap_schema=TEST:CRMB Import: Release 12.1.0.2.0 - ...