Oracle Drop User statement delete user from the database and remove all objects owned by the schema. This query will…
This post explains how to check Oracle version information running on Linux and windows. Description You can check Oracle version…
The Oracle system identifier ” already exists, specify another SID ” error occurs during database creation using dbca utility. It…
You can remove or delete/reset spfile parameter in Oracle Database using alter system reset command. After changing the parameter you…
In this article we will discuss about enabling Transparent Data Encryption – TDE in Oracle 19c. To configure Auto Login…
You may need to find out OS PID from sid in Oracle to check the performance related to OS and…
As a DBA, you must check Oracle database performance and generate database health check report on periodic basis to get…
You can check index on a table in Oracle using DBA_INDEXES view and using dba_segments you can check size of…
During Oracle RMAN database backup, database must be in archivelog mode for RMAN backup. If you want to take database…
You can use Oracle encryption password to encrypt export dumpfile. You can use TDE encryption feature for full database export…