Wednesday, December 30, 2020

Create a Listener in Oracle Database 19c

Create a Listener in Oracle Database 19cIn this guide, you will learn how to create a listener in Oracle Database 19c with NETCA and Oracle Net Manager.A listener is a processus allowing to serve a connection to a database instance via a network protocol (TCP / IP, IPC,...

Monday, December 28, 2020

Upgrading to Oracle Database 19c (Non-CDB) - 11g to 19c

This article provides an overview of upgrading an existing non-CDB database to Oracle 19c. Upgrades can be very complicated, so you must always read the upgrade manual, and test thoroughly before considering an upgrade of a production environment.This article also includes the conversion of the upgraded database to...

Friday, December 25, 2020

Introduction of Relational Model and Codd Rules in DBMS

TerminologyRelational Model: Relational model represents data in the form of relations or tables.Relational Schema: Schema represents structure of a relation. e.g.; Relational Schema of STUDENT relation can be represented as:STUDENT (STUD_NO, STUD_NAME, STUD_PHONE, STUD_STATE, STUD_COUNTRY, STUD_AGE)Relational Instance: The set of values present in a relation at a particular...

Wednesday, December 23, 2020

A Simple Guide for Migration of data to Autonomous Database using EM

Moving the workloads of your on-premises database to an Oracle Cloud gives you a competitive advantage today. Databases in Oracle Cloud leverage Oracle's Generation 2 infrastructure, providing maximum performance, better pricing, and the most secure environment for your enterprise workloads. OCI also provides the Oracle Autonomous Database, the...

Pages (26)1234567 »