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 SYS...
ORA-
ORA-28081: Insufficient privileges – the command references a redacted object
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 ...
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 instan...
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 recover...
ORA-12720: operation requires database is in EXCLUSIVE mode
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 SO...
ORA-00997: illegal use of LONG datatype
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_or...
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 ch...
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 referenc...
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: tab...
ORA-12984: cannot drop partitioning column
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...
