Oracle

By - rgonzalezpinto
Published on Oracle

Oracle Data Pump: Practical Export and Import Techniques Using ` EXCLUDE ` and `QUERY`

In this post , we'll look at several scenarios involving exports that can be very useful. Often, we need to exclude objects from our export or filter specific data in our export; in these cases, we use the EXCLUDE (to omit objects) or QUERY (to filter the records to be exported) parameters. We'll use the schema

By - rgonzalezpinto
Published on Oracle

Convert a cdb database cdb pdb

In this post explain how to convert a non-CDB database into a PDB database PDB an existing container using the “Plugging aCDB CDBmethod. We’ll start with the following scenario: On a machine, we have atestnon-CDB database that we’re going to migrate to

By - rgonzalezpinto
Published on Oracle

Upgrade PDB 19c 26ai Autoupgrade

In this post explain how to upgrade a database from 19c 26ai. To do this, I’ll walk you through the process using Autoupgrade Oracle update Advisor proactively identify and resolve issues before proceeding with the upgrade. On the same machine (oracle19cdb1), we’ll migrate a database

By - rgonzalezpinto
Published on Oracle

Install Step-by-Step Guide to Installing Oracle AI Database 26ai Linux

In this post explain how Install Oracle Database 26ai Linux 9 in detail, step by step. 1- Download the software download the software, use the following link.software On this page, you will find the software available for download. Download the ZIP file for the Oracle platform

By - rgonzalezpinto
Published on Oracle

Customize SQL*Plus

You may have occasionally needed to customize your connection to your Oracle database using SQL*Plus. In this post , I’ll show post the basics of how to do it. Follow this link: Customizing SQL*Plus The blog

By - rgonzalezpinto
Published on Oracle

Cambiar el DBID y el nombre de una Base de datos (DB_NAME) con DBNEWID

DBNEWID is a database utility that allows you to change a database's internal identifier (DBID) and database name (DBNAME). You can change only the DBID, only the DBNAME, or both the DBID and the DBNAME. This action, prior to the introduction of the utility

By - rgonzalezpinto
Published on Oracle

Creating a Virtual Network (VCN) in Oracle OCI

This link an example of how to create a Virtual Network (VCN) in Oracle OCI. Create VCN OCI

By - rgonzalezpinto
Published on Oracle

Provision Database software Images Oracle OCI

In this post walk through an example of how to provision software in an OCI environment. As an example, we’ll provision a software image software an ExaCC Oracle Exadata on Cloud@Customer) environment. For our test, we’ll create an Oracle Database 26ai image 26ai can then be deployed to

By - rgonzalezpinto
Published on Oracle

Oracle Data Masking

In this post carry out a practical case study using the Oracle Data Masking and Subsetting Pack. Data masking is the process of permanently replacing confidential data with fictitious data. The aim is to remove confidential data from testing, development, analytics, and other non-production environments. Before

By - rgonzalezpinto
Published on Oracle

Oracle tables – Avoid drops and deletes (Blockchain Tables)

In version 19c introduced a very interesting feature, giving administrators the ability to create tables where only insert operations are allowed, where row deletion is prohibited or can be restricted for a set period of time, and where it is also possible to restrict table deletion. It is important to note that