In the database, it may sometimes be necessary to disable system triggers during operations such as java installation, downgrade, or upgrade. An error in a …
Read More »
In the database, it may sometimes be necessary to disable system triggers during operations such as java installation, downgrade, or upgrade. An error in a …
Read More »While current transaction waiting for a lock in a session, the following error will occur in the database when the corresponding session terminated unexpectedly with …
Read More »When a user tries to create a materialized view in a different schema, if the user of that schema does not have create table authority, …
Read More »The Oracle Database Security Assessment Tool (DBSAT) analyzes database configurations and security policies to help eliminate security risks and improve database security. Using the DBSAT …
Read More »We use the incremental backup of the primary database to fix the gap that occurs in the standby databases. If the managed recovery is turned …
Read More »kfed and kfod are under $ORACLE_HOME/bin. With these tools, we can learn about asm disks and edit the information in the disk headers. When using …
Read More »The serial numbers and part codes of the compute nodes and cellnodes and components in these nodes in the Exadata are required to supply the …
Read More »The READ object privilege introduced with the 12c (12.1.0.2) version. It allows us to read a table without locking. It is used to create read-only …
Read More »Oracle Direct NFS (dNFS) is an optimized NFS client that provides faster and more scalable access to NFS storage in NAS storage devices. Direct NFS …
Read More »With the disable_archive_logging parameter, which is a feature introduced with Oracle 12c, we are able to import without producing redo in a database in archivelog …
Read More »