SET ROWLIMIT in Oracle 18c

Sets a limit for the number of rows to display for a query. By default, ROWLIMIT is OFF. SET ROWLIMIT {n | OFF} n can be any number between 1 and 2,000,000,000. An error is displayed when the value that is entered is outside this range. OFF displays all the rows in the output. Example To set […]

Read More

Duplicating a PDB to an Existing CDB in Oracle 18c

Use the DUPLICATE command to duplicate a PDB to an existing CDB. To duplicate a PDB to an existing CDB: Ensure that the required prerequisites are met. Review the limitations of duplicating a PDB to an existing CDB Create the directories that store the duplicate database files on the destination CDB Establish Oracle net connectivity […]

Read More

createPluggableDatabase with DBCA in Oracle 18c

In this post, we can use createPluggableDatabase command creates a pluggable database (PDB) in a multitenant container database (CDB) with DBCA in Oracle 18c.

Let’s connect to the database and check the PDB is created or not.

In the next post, we can delete the PDB with DBCA in Oracle 18c. Stay tuned for more […]

Read More

deletePluggableDatabase with DBCA in Oracle 18c

In this post, we can use deletePluggableDatabase command creates a pluggable database (PDB) in a multitenant container database (CDB) with DBCA in Oracle 18c.

Let’s connect to the database and check the PDB is deleted or not.

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the […]

Read More

createDuplicateDB with DBCA in Oracle 18c

We can use createDuplicateDB command duplicates a database with DBCA in Oracle 18c. Syntax and Parameters Use the dbca -createDuplicateDB command with the following syntax:

For creating the duplicate database, our primary database must be in archive log, otherwise we will get an error.

Run the following command to create a duplicate database.

Stay tuned for more […]

Read More

executePrereqs with DBCA in Oracle 18c

The executePrereqs command executes the prerequisites checks and reports the results. This command can be used to check the environment before running dbca to create a database. Syntax and Parameters Use the dbca –executePrereqs command with the following syntax:

Run the DBCA with executePrereqs

Stay tuned for more articles on Oracle 18c  Thank you […]

Read More

Shadow Tablespaces in Oracle 18c

A shadow tablespace is a bigfile tablespace intended for shadow lost write protection. Purpose of Shadow Tablespaces Shadow lost write protection provides fast detection and immediate response to a lost write. A data block lost write occurs when an I/O subsystem acknowledges the completion of the block write even though the writers did not occur or when a former […]

Read More

Image-Based Oracle Database Installation in Oracle 18c

Starting with Oracle Database 18c, installation and configuration of Oracle Database software are simplified with the image-based installation. To install Oracle Database, create the new Oracle home directory, extract the image file into the newly-created Oracle home, and run the setup wizard to register the Oracle Database product. Using image-based installation, you can install and […]

Read More

Cancel Session in Oracle 18c

As of Oracle 18c , you can not only abort a database session, but also just a single SQL command. This tip shows how it works. There are situations where the execution of SQL commands takes too long and there is a desire to cancel them. Be it because the SQL command is incorrect, or […]

Read More

Oracle Data Pump Changes in Oracle Database 18c

Oracle Data Pump, Export, and Import The Data Pump Import DATA_OPTIONS parameter has a new CONTINUE_LOAD_ON_FORMAT_ERROR option. If Data Pump encounters a stream format error when loading table data, Data Pump attempts to skip forward to find the start of the next row and continue loading that data from that location. For security purposes, Data […]

Read More