PFILE and SPFILE in Oracle Database and How can you create PFILE and SPFILE?


This article describes PFILE and SPFILE in Oracle Database in details from where you will knowWhat is PFILE and SPFILE?File LocationWhat is difference between PFILE and SPFILE?Advantages of SPFILEsHow to create PFILE and SPFILE? How can we modify PFILE and SPFILE?How to SHOW Parameter in SPFILE?What is PFILE and What......

Step by Step Oracle Database 19c Installation On Oracle Linux 7 (OL7)


Oracle Database 19c is the latest version for production use and this article describes the all steps to install of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit. This article is divided into several sections:Installation requirements ChecklistDownload SoftwareInstallation Prerequisites StepsOracle Installation stepsDatabase CreationFinal Checking database: Installation requirements ChecklistPlease check the checklists......

Uninstall Oracle 19c in Windows and Unix/Linux to remove Oracle software and configuration files completely.


Sometimes we need to remove or un-install Oracle Database from our computer. These topics describe how to remove Oracle software and configuration files for version Oracle 19c in Windows and Unix/Linux.Uninstalling oracle database is little bit complex in 12c because it sets different file in different location during install.......

Uninstall Oracle 12c in Windows and Unix/Linux to remove Oracle software and configuration files completely.


Sometimes we need to remove or un-install Oracle Database from our computer. These topics describe how to remove Oracle software and configuration files for version Oracle 12c in Windows and Unix/Linux.Uninstalling oracle database is little bit complex because it sets different file in different location during install. If properly......

What is OLTP and OLAP? Why is it important in Database Design?

What is OLTP and OLAP? Why is it important in Database Design?

There are two kinds of database depending on processing: transaction based and analytical based. So before starting database design, first we must analyze the nature of the application what we are designing for, is it Transactional based database or Analytical based database. OLTP: OLTP stands for Online transaction processing which deals with......

Exporting and Importing large database file(SQL) in MYSQL/Maridb using command line


Phpmyadmin does not support large files to import in mysql database. So use of command line is the best way to export or import large files in mysql database. Here are the steps to export and import a file in mysql using command line.Prerequisite Steps: To import and/or export......

Md Saidul Haque
Software Architect

Learn more

knowledge base

A collection of articles, tutorials, courses and solution of problems

Add Your Knowledge Base

Tags