ORA-

ORA-15260: permission denied on ASM disk group

PROBLEM: While creating a diskgroup , got ORA-15260: permission denied on ASM disk group error. [oracle@19c]$ sqlplus / as SYSDBA SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 18 18:42:58 2021 ...

ORA-01442: column to be modified to NOT NULL is already

PROBLEM: Got error while doing online redefinition of a table, ORA-01442: column to be modified to NOT NULL is already NOT NULL. DECLARE error_count pls_integer := 0; BEGIN DBMS_REDEFINITION.COPY_TABL...

ORA-14024: number of partitions of LOCAL index must equal that of the

PROBLEM: While doing online redefinition of partitioned table, got ORA-012024 error. SQL> DECLARE 2 error_count pls_integer := 0; 3 BEGIN 4 DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS('RAJDBA', 'SOC_TA...

ORA-16855: transport lag has exceeded specified threshold

PROBLEM: We have observed below error in dgmgrl : DGMGRL> show database prdstby Database – prdstby Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 9 minutes 24 seconds (compute...

ORA-32774: more than one file was specified for bigfile tablespace

PROBLEM: While creating bigfile tablespace with multiple datafile, got error as ORA-32774: more than one file specified SQL> create bigfile tablespace BIGTS datafile ‘/dmdata02/oradata/BSDMSI...

ORA-32773: operation not supported for smallfile tablespace

PROBLEM: While enabling autoextend for an tablespace, got error like ORA-32773: operation not supported for small file table space. SQL> alter tablespace SMALLTS autoextend on; alter tablespace SMA...

ORA-01536: space quota exceeded for tablespace

PROBLEM: While creating a table or inserting data, user is getting error ORA-01536: space quota exceeded for tablespace . SQL> create table OBJCOPY tablespace SMALLTS as select * from dba_objects; ...

ORA-02304: invalid object identifier literal while import with CREATE TYPE OID

 PROBLEM: While importing schema objects, got below errors. ORA-39083: Object type TYPE:”PADADM10″.”NAME_AND_COUNT_ARRAY” failed to create with error: ORA-02304: invalid objec...

ORA-01950: no privileges on tablespace ‘USERS’

PROBLEM: While creating a table using CTAS, got an error, ORA-01950: no privileges on tablespace ‘USERS’. SQL> create table DBACLASS.EMPLO as select * from user_objects; create table E...