How to Duplicate a Schema from One to Another
Suppose you are planning to duplicate user01 schema into user02 schema. Tools like TOAD, SQL Developer can be helpful. But you may also like to… Read More »How to Duplicate a Schema from One to Another
User and Schema
How to Resolve ORA-12034: materialized view log on younger than last refresh
ORA-12034 Found an error ORA-12034 in alert log: ORA-12034: materialized view log on younger than last refresh Rationale ORA-12034 means that your last refresh older… Read More »How to Resolve ORA-12034: materialized view log on younger than last refresh
How to Stop Account Password Expired Notice in Oracle
Make sure that you're in the right database. SQL> select name from v$database; NAME --------------------------- ORCL Check what profile the user is applied. SQL> select… Read More »How to Stop Account Password Expired Notice in Oracle
How to Resolve ORA-01401: inserted value too large for column
We saw a materialized view snapshot error in alert log....ORA-12012: error on auto execute of job 854ORA-12008: error in materialized view refresh pathORA-01401: inserted value… Read More »How to Resolve ORA-01401: inserted value too large for column
Every Aspect of KILL SESSION and DISCONNECT SESSION
Oracle SQL provides end_session_clauses syntax to terminate sessions:ALTER SYSTEM { DISCONNECT SESSION 'integer1, integer2' [ POST_TRANSACTION ] | KILL SESSION 'integer1, integer2 [,@integer3]' } [… Read More »Every Aspect of KILL SESSION and DISCONNECT SESSION
What Schema Objects are Stored in SYSTEM Tablespace by Default
Where do stored procedures reside in? The quick answer is SYSTEM tablespace. Oracle documentation (Logical Storage Structures of 18c) mentions about SYSTEM tablespace as this:… Read More »What Schema Objects are Stored in SYSTEM Tablespace by Default
How Many Schema Object Types Can You Have
It seems that Oracle does not list all the schema object types exhaustively in the documentation: Schema Object Types So, if you'd like to know… Read More »How Many Schema Object Types Can You Have
How to Resolve ORA-01406: fetched column value was truncated
Found ORA-01046 in the alert log of a 8i database:...Errors in file /oracle/admin/orcl/bdump/orcl_snp2_43589.trc:ORA-12012: error on auto execute of job 6859ORA-12008: error in snapshot refresh pathORA-01406:… Read More »How to Resolve ORA-01406: fetched column value was truncated
Why Does Force Refresh Produce Huge Archived Logs
In one day, I found archived logs grew very fast, they were generated almost 10 times comparing to normal business days, and could make the… Read More »Why Does Force Refresh Produce Huge Archived Logs
How to Resolve ORA-12008: error in materialized view refresh path
This error means something prevent the snapshots from reading the master tables when refreshing the snapshots.The possible causes could be:Columns have been added into the… Read More »How to Resolve ORA-12008: error in materialized view refresh path