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-
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-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
PROBLEM: Application team was running some upgrade and during that process, they got the below error. ORA-20101: ERROR at line 1: ORA-20101: PGIDX is not a ASSM (Automatic Segment Space Management) t...
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...