Datapump EXPDP/IMPDP Realtime Course For Oracle DBA'S

Master installing Oracle Linux 7.8 in VirtualBox, configure storage and partitions, set root and user credentials, accept the license, and complete the setup.

Configure VirtualBox for Oracle on OEL 7.8 by creating a virtual machine, naming and locating it, allocating memory (min 4 gb), and setting disk size before installation.

Configure network adapters by opening settings, selecting the host-only network, enabling the adapter, and enabling internet sharing to connect Oracle and the X server.

Configure IP addresses on the OEL server using host-only and bridged adapters, set a manual IPv4 with a netmask, verify with ifconfig, and disable the firewall for VM access.

Configure putty to connect to the vm, enable X11 forwarding for graphical applications, and set and verify the hostname to complete the remote setup.

Install the Oracle database on Oracle Linux using the preinstall package and configure prerequisites, soft and hard limits, the inventory file, and Oracle user permissions.

Learn how to copy a database dump file from Windows to a Linux VM using minisub, including setting IP, username, and password, then drag-and-drop across the two boxes.

Install Oracle database software by configuring inventory and base locations, adjusting ownership, and launching the graphical installer from root to complete a single instance database installation within 10–15 minutes.

Install the Oracle database 12cR1 and configure the listener on port 1521. Enable archiving and the fast recovery area, set up directories, and enable sample schemas with UTF-8.

Learn the basic prechecks before starting datapump export and import, including sample schemas, directory creation, object size and free space checks, grants handling, and version considerations.

The session explains the roles and privileges required to use datapump export and import (expdp/impdp), including granting group and database permissions, and practical notes on PDB and directory access.

Export and import a customers table across schemas using datapump, and learn mandatory parameters, environment setup, directory, dumpfile, logfile, and remap schema with replace options.

Learn to clone a VM to create a production database environment, use a new VM for dpprod, generate new MAC addresses for all network adapters, then power on.

Log into the server, open wired settings, and change the IP address for the new server; then update the host name, save, reboot, and verify IPs in the terminal.

Configure the Oracle listener and tnsnames for dpprod to update instance, host, and service name settings. Stop the listener and verify the database status and service name for reliable connections.

Rename the oracle database from dptest to dpprod using the NID utility, after stopping the database, updating files, and restarting with the new name.

discover how to set up a dpprod init environment by renaming the database, moving control files, updating password files, and configuring environment variables to start from the new location.

Learn multiple ways to monitor datapump jobs using expdp and impdp, log files, and database views, tracking master and worker processes, progress, and available monitoring scripts.

Enable tracing for the datapump master and worker processes to troubleshoot export-import jobs, using 83 for the master and 400/300 for the workers, guided by the XML value references.

Create and use a parfile, a parameter file, to bundle expdp and impdp parameters, simplifying large exports or imports and reducing mistakes when listing many tables.