PROBLEM: Granting tablespace quota to a user is failing with ORA-30041. SQL> alter user dba_raj quota unlimited on TEMP ; alter user dba_raj quota unlimited on TEMP * ERROR at line 1: ORA-30041: Cannot grant quota on the tablespace SQL> alter user dba_raj quota unlimited on undotbs1; alter user dba_raj quota unlimited on undotbs1 * […]

PROBLEM: While assigning default tablespace for a user, got an ORA-12910 error. SQL> alter user dba_raj default tablespace TEMP; alter user dba_raj default tablespace TEMP * ERROR at line 1: ORA-12910: cannot specify temporary tablespace as default tablespace SOLUTION: As the error says, we can’t set a temporary tablespace as default tablespace for a user. […]

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

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

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

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

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

PROBLEM: Archive logs are not getting deleted with RMAN command, and it is reporting below warnings. RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=/archive/arch/BBCRMDEV/1_1963_929123254.dbf thread=1 sequence=1963 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=/archive/arch/BBCRMDEV/1_1964_929123254.dbf thread=1 sequence=1964 RMAN-08137: […]

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