AITB International Conference, 2019

Kathmandu, Nepal

My Youtube Channel

Please Subscribe

Flag of Nepal

Built in OpenGL

World Covid-19 Data Visualization

Choropleth map

Word Cloud in Python

With masked image

Showing posts with label oracle. Show all posts
Showing posts with label oracle. Show all posts
Thursday, May 29, 2025

List of important Data Dictionary queries in Oracle 19c

›
 Here's a comprehensive list of important Data Dictionary queries in Oracle 19c and the useful information you can extract from each. ...

ERD of Oracle HR Schema

›
 

Process to import SAKILA Schema in Oracle database

›
 #####Create a directory for sakila files mkdir /u01/app/oracle/sakila cd /u01/app/oracle/sakila -------------------------------------------...
Monday, May 26, 2025

Explanation of Parameters of Control file used while creation in Oracle Database

›
  CREATE CONTROLFILE REUSE DATABASE "ORCLTRN" NORESETLOGS  ARCHIVELOG     MAXLOGFILES 16     MAXLOGMEMBERS 3     MAXDATAFILES 100 ...
Thursday, February 1, 2024

Steps to install oci8 on centos 8

›
The following steps is valid for Oracle 11g, you can modify as per your oracle version in a similar fashion. 1. Install the Oracle Instant C...
Tuesday, August 22, 2023

Physical IP Vs Virtual IP Vs SCAN IP (with Examples)

›
Physical IP, Virtual IP, and SCAN IP are terms often used in the context of networking and IT infrastructure. Let's break down the diffe...
Tuesday, July 25, 2023

What is Archive logs in Oracle database?

›
An archive log is a term commonly used in the context of database management systems, particularly with relation to Oracle Database. In a da...
Saturday, June 3, 2023

Differences between Datafile and Tablespace

›
  Datafile Tablespace Definition Physical file used by the DBMS to store data Logic...
Friday, June 2, 2023

Real Application Clusters (RAC) in database

›
RAC stands for Real Application Clusters, and it is a feature of Oracle Database that allows multiple instances (database servers) to simul...