Tuesday, March 2, 2021
    Home Oracle DBA Tips

    Oracle DBA Tips

    How to enable Archivelog

    This blog post explains how to enable archive log mode in Oracle database for newest versions.

    Migration methods of Oracle Database

    Blog post explains which tricks and methods are simple to perform migration of small and large Oracle database

    Export and Import in Oracle XE

    This article will focus on exporting and importing Oracle XE database through the DATA PUMP programs using commands of Expdp and Impdp.

    Virtual columns in Oracle

    The blog post provides information about Virtual columns in Oracle, about how to create and what are the usage in Oracle 11g onward version.

    Archive Log Basics

    The article explains about basics of Archiving process and usage of arch files in backup and recovery.

    Managing Oracle Instance

    The article explains an overview of how to manage Oracle instance and location of Oracle home

    Daily backup of Schema Scheduling

    The article explains how to schedule the daily export backup of schema with date and time in the dump file.

    SQL Server Concept for Oracle DBA

    Article explains basic concept of SQL server for understanding to Oracle DBA what is the master database and user database etc

    Some detail about login.sql

    Article explains about login.sql and banner.sql of Oracle 18c database for information usages.

    Create Schema in Oracle 18c XE

    Article explain how to create new user in Oracle 18c XE and grant some system privileges with connect as new schema user in database.

    Recover database from dump File

    Detail explanation and step by step guide for how to recover database using import dump file manually.

    SQL Tracing-Overview

    Detail explanation of how to enable and disable SQL tracing in a database with database level or session level with how to understand the result of a trace.
    - Advertisment -

    Most Read