Tablespace Management in Oracle. A Tablespace is a logical storage unit within an Oracle database. It is logical because a table space is not visible in the file system of the machine on which the database resides. A table space, in turn, consists of at… Read More
How to Install VMware Workstation On Windows. VMware Workstation is a hosted hypervisor that runs on x64 versions of Windows and Linux operating systems (an x86 version of earlier releases was available);[3] it enables users to set up virtual machines (VMs) on a single physical machine, and use them simultaneously along with the actual machine. Each… Read More
DATABASE CREATION Oracle Database can create by using the following 3 methods Manual database creation OMF method (Oracle Managed database Files) DBCA method (Database Configuration Assistance) In this article we will discuss Manual database creation. Steps to create database in manual method. Declare… Read More
Startup and Shutdown modes in Oracle In this article we will discuss different STARTUP and SHUTDOWN MODES. Startup Modes : Startup nomount Startup mount Open Startup restrict Startup force Startup suspend Before reading article please check below image Startup Nomount : Oracle open… Read More
Dear Readers, In this article, we will see the following DDL Logging in Oracle 12c. What is DDL Logging ? Concerning the Data Definition Language log, or DDL log, in previous releases, there wasn’t any direct option available to log the DDL command/action. Like an… Read More
Dear Readers, In this article, we will see the following Temporary Undo in Oracle 12C. Temporary Undo in 12C Undo tablespaces facilitate the rollback of logical transactions. In addition, undo tablespaces support a number of other features, including read consistency, various database-recovery operation, and flashback… Read More
MYSQL TO ORACLE DATABASE LINK CREATION USING HETEROGENEOUS SERVICES A database link is a pointer that defines a one-way communication path from an Oracle Database server to another database server. The remote database can be same oracle or it can be non-oracle database. To access… Read More
DATABASE LINK IN ORACLE What is database link? A database link is a schema object in a database. The main purpose of the database link is to access database objects present in another database or remote database. A database link creates a connection between a… Read More
Automatic Diagnostic Repository ADR – Automatic Diagnostic Repository (introduced in Oracle 11g) is a system managed repository for storing database alert logs, trace files, and any other diagnostic data previously controlled by any other init.ora parameters. DIAGNOSTIC_DEST is the base location for all diagnostic directories. There… Read More
There is no excerpt because this is a protected post.
