It has been seen in cases where ORA-16401 and ORA-16055 reported in primary alert log when redo log switch is...
Month: July 2023
Database server crashed after memory on server used by inactive sessions The Following Example used to illustrate the scenario for...
We may need to find the database growth for different periods in the past. This Article provides the queries to...
Below Are the differences b/w exp/imp vs Datapump 1. Datapump operates on a group of files called dump file sets....
When executing a Materialized View refresh an ORA-01555 is returned. This returns the following type of error either in the...
Refreshing a Materialized View via the Oracle job scheduler reports the following errors, however manual refresh succeeds. *** SERVICE NAME:(SYS$USERS)...