Upgrade Oracle 11 to 19c for Windows—Part Two

Oracle® 19c Database is the latest release of a widely adopted automation database in the market and enterprises. Stability is an important element of the Oracle Database 19c component of the Oracle Database 12c (Release 12.2) family of products. In this two-part blog post series, I cover installing and upgrading version 19c.

Read More

Install Oracle 19c for Windows—Part One

Oracle® 19c Database is the latest release of a widely adopted automation database in the market and enterprises. Stability is an important element of the Oracle Database 19c component of the Oracle Database 12c (Release 12.2) family of products. In this two-part blog post series, I cover installing and upgrading version 19c.

Read More

Restore Oracle database by using RMAN duplicate in Oracle 12c

Oracle® Recovery Manager (RMAN) is a tool that can duplicate or clone a database from a backup or from an active database. RMAN can create a duplicate database on a remote server with the same file structure, on a remote server with a different file structure, or on the local server with a different file structure.

Read More

Unplugging and plugging multitenant databases

This blog discusses detaching one pluggable database (PDB) from the source container database (CDB) and attaching it to a target CDB. For the purposes of this blog, the PDB is the database in which we save all our application-related databases.

Read More

Oracle online table partitions using the DBMS_REDEFINITION package

Starting with Oracle® 10g, you can partition tables online without any application downtime by using the DBMS_REDEFINITION package.

Use the following steps to change a non-partition table to a partition table by using DBMS_REDEFINITION. This example changes the non-partition table, TABLEA, to a range interval partition table.

Read More