Oracle Basic DBA(Database Administration)

Topic Introduction: In this tutorial, we will discuss Oracle Basic DBA(Database Administration) by which we can manage the most essential work to Installing Database and this related software such as oracle apex, forms reports, etc & managing Database. If we work on the Oracle Platform we need to know minimum knowledge of DBA which will help us to set up our oracle environment on a PC or Server. A list of topics is given below.

Installation & Uninstallation

• Oracle Database 19c Installation on windows 10
• Oracle Database Uninstall (Manually)
• Oracle Forms & Report Installation
• Oracle Apex Installation

Backup & Restore

• Oracle Schema Restore (Data Pump)
• Oracle Schema Backup (Data Pump)

Object Create

• Table Creation on Oracle Database
• Oracle Schedule Jobs Creation
• Oracle Database Link (DBLINK)

Others

• Get Current Schema and Database Name
• Schema Unlock