PROBLEM: While trying to drop a column from a table, owned by SYS, got below error.(ORA-12988) SQL> show user USER is "SYS" SQL> alter table test3 drop ( CREATED); alter table test3 drop ( CREAT...
ORA-
ORA-19381: cannot create staging table in SYS schema
PROBLEM: While creating a staging table in oracle database for SYS user, for storing baseline, got below error.(ORA-19381) SQL> show user USER is "SYS" BEGIN DBMS_SPM.CREATE_STGTAB_BASELINE( table_...
ORA-12839: cannot modify an object in parallel after modifying it
PROBLEM: We did one DML transaction without parallel, and in the same session, when we did another DML transaction with parallel, we got error as ORA-12839. SQL> ALTER session enable parallel dml; ...
ORA-12719: operation requires database is in RESTRICTED mode
PROBLEM: While dropping a database in mount stage got below error.(ORA-12719) SQL> startup mount; ORACLE instance started. Total System Global Area 1.4663E+10 bytes Fixed Size 15697000 bytes Variab...
ORA-12841: Cannot alter the session parallel DML state within a transaction
PROBLEM: While enabling parallel DML option, after doing some transaction, got error ORA-12841 SQL> insert into test2 select * from dba_objects; 77635 rows created. SQL> alter session enable par...
ORA-12838: cannot read/modify an object after modifying it in parallel
PROBLEM: After doing insert operation in parallel, when I tried to run the select query it is throwing error ORA-12838. SQL> alter session enable parallel dml; Session altered. SQL> insert /*+ p...
ORA-02396: exceeded maximum idle time, please connect again
PROBLEM: The application is unable to connect to the database after it was idle for a long time. Error ORA-02396: exceeded maximum idle time, please connect again was logged in the application log. SO...
ORA-13541: system moving window baseline size greater than retention
PROBLEM: While modifying the retention period of AWR snapshot, got error ORA-13541 SQL> execute dbms_workload_repository.modify_snapshot_settings (interval => 30, retention => 10080); BEGIN d...
ORA-1495 :specified chained row table not found
PROBLEM: While analyzing the table for chained rows, got below error. ORA-1495 ANALYZE TABLE SCOTT.EMPTAB LIST CHAINED ROWS; * ORA-1495 specified chained row table not found SOLUTION: To fix it run t...
ORA-32001: write to SPFILE requested but no SPFILE is in use
PROBLEM: While altering parameter in parameter file got below error. ALTER SYSTEM SET processes = 900 SCOPE=SPFILE; ALTER SYSTEM SET processes = 900 SCOPE=SPFILE * ERROR at line 1: ORA-32001: write to...