Tuesday, 21 January 2025

Understanding Vagrant - Day 1

I know I am late but finally I got the opportunity to see what VAGRANT is all about. In this article, I am going to cover everything I'll go as part of my 1st learning experience with VAGRANT so if you are also new to this, let's see it together.

Installing Vagrant:

You can download the latest Vagrant software here. For me, it's Version: 2.4.3 and I have downloaded AMD64 for my Windows machine.

The installation is quite easy so if you have every installed any software, it should not be difficult for you.

Monday, 20 January 2025

Using INCLUDE/EXCLUDE options in Oracle EXPDP/IMPDP

Within Oracle Datapump parameters, you can specify a set of objects to be included or excluded from an Export or Import operation, such as tables, indexes, grants, procedures.

EXCLUDE and INCLUDE and mutually exclusive parameters, that means you can only specify 1 of them at a time in EXPDP or IMPDP commands. Below shown in the syntax,

EXCLUDE = object_type[:name_clause] [, ...]
INCLUDE = object_type[:name_clause] [, ...]

Examples:

expdp ... SCHEMAS=scott EXCLUDE=SEQUENCE, TABLE:\"IN ('EMP', 'DEPT')\"
impdp ... SCHEMAS=scott INCLUDE=FUNCTION, PACKAGE, TABLE:\"= 'EMP'\"

Sunday, 19 January 2025

Using EXPDP/IMPDP for an Object or Schema in Oracle Database

With data pump, it is possible to export a single table or entire schema, and not just full database, which makes it pretty convenient for such cases. Data Pump gives you better control to manage logical structure of your database and hence in this article, we are going to see how we can export/import a single table or entire schema if needed.

Saturday, 18 January 2025

Install Sample Schemas in Oracle Database 19c

Sample schema is very important especially at your learning phase as it gives you access to an already creates schema's which are having objects with some sample data for your use.

With these sample schemas, you already have some data existing in your database to play with.

Using EXPDP to export a Pluggable Database (PDB)

You can export a pluggable database just like you would export a non-container database or even a container database for that matter. But normally container data is supposed to collect metadata & dictionary information for all PDBs and not the user/application data.

If you haven't configured LISTENER.ORA or TNSNAMES.ORA for PDB, it would be good time to do it now.

Using EXPDP to export a Full Oracle Database and break into multiple DUMP Files

Using EXPDP to export a FULL Oracle database backup is an easy task. It gets a little complex when you have specific requirements with what to extract, for example: export a single table or schema, or some particular query output, or INCLUDE some list of object and vice versa i.e. EXCLUDING some objects from the backup. Well I intend to provide a full picture on various options with examples but it will increase the post length to uncontrolled manner so I'll break down each type of activity and then create a MASTER article explaining all features for your help.

Wednesday, 15 January 2025

Cloning a non-container database (non-CDB) to pluggable database (PDB)

Converting a non-CDB to PDB is very easy, thanks to DBMS_PDB package provided by Oracle from 12c onwards. DBMS_PDB allows to you create an XML and generate the metadata for non-CDB just like you'll create it when you unplug any PDB.