Oracle

I will explain How to Move Rename and Relocate Datafiles in Oracle database.

I will explain What is the Tablespace in Oracle in this post.

I will explain How to Export and Import Specific Table Partition and Where Condition in Oracle Datapump in this article. Let’s review the Export ( Expdp ) Specific Table Partition …

Suppose that we have a table of 10 rows in which only the first 5 rows are used / required by the application team. As a DBA, we can decide …

Install Swingbench 2.6 To install Swingbench release 2.6, all you need to do is ensure you have a Java 8 JVM available, to check java version use command, you must …

Block change tracking (BCT) is an oracle feature that improves the performance of incremental backups.

Let’s say we want to create a database user who logs in with their OS account. To do so, we will use the “external authentication” option offered by oracle. Check the …

The following initialization parameters are new in Oracle Database 19c: In Oracle 19c database Oracle introduced six parameters. We know that parameter plays very important role in database.   You …

Hi, I will share with you Step by Step RMAN Backup, Restore and Recovery Tutorials For Beginners in the Oracle Database in this article.

Hi, I will explain What is the Optimizer Hints and How to Use Hints in Oracle in this article.