ORA-01031 WHEN CONNECTING TO ORACLE 12C WITH TOAD 11.6
ISSUE A user cannot connect to Oracle Database 12c with Toad. He gets ORA-01031: insufficient privileges every time when attempting to connect. REASON In 12c release an access to SYS.USER$ table has been restricted. SOLUTION The issue only related to TOAD of…
TROUBLESHOOTING THE ORA-00600 ERROR WHILE A “MATERIALIZED VIEW” IS BEING CREATED OR COMPILED
ISSUE A database writes ORA-00600 [qsmkzfs:NULL seminfo] errors into the alert log everytime when a materialized view is being created or being compiled. RELATED ORA-00600 [qsmkzfs:NULL seminfo] While Compiling A Materialized View / Alter Summary (Doc ID 2069148.1) RETRIEVING AN OBJECT’S DDL STATEMENT…
ORA-1555: SNAPSHOT TOO OLD DUE TO CORRUPTED LOBS
QUESTIONS During schema(s) export or querying a table containing a clob column I recieve the following error ORA-01555: snapshot too old: rollback segment number with name “” too small SOLUTION Usually the ORA-01555 error is related either to the undo retention and the…
Search
Categories
- Linux (7)
- Networker (1)
- Oracle (43)
- Account (2)
- AWR (1)
- Database Errors (3)
- Datapump (1)
- Enterprise Manager (12)
- Environments (4)
- Interview (1)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- PL/SQL (4)
- UTL_FILE (4)
- Prerequisites (1)
- Redologs (1)
- Segment Shrink (1)
- Session (3)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Statistics (2)