
Explore realtime datapump expdp/impdp administration through hands-on scenarios, monitor sessions in real time, optimize performance across Oracle versions 12c and 19c, and troubleshoot datapump tasks for DBAs.
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.
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.
To create dummy data for refresh, we create a sample table and populate rows in it using a simple 'for' loop
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.
Objective:
Practice makes perfect ! Master datapump utility by performing different hands on lab scenarios with this course
Oracle datapump tool boosts the migration of data and metadata from source database to destination database. It is also the most widely used utility in oracle database for data copy,refresh, etc and also used in cloud migrations. So learning this tool help you in your career.
This course is for oracle learners who want to learn datapump utility in oracle for performing different methods of data copy and refresh data
In this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasks
All the parameters will be used in the practical box for different oracle versions
Oracle machine is built in virtual box for simulation of the tasks
Learners can be able to confidently face a request from application team after completing the course
Datapump is the core of this course. So only datapump utility will be explained
Hope the learner who applies for this course has a prior understanding of what oracle database is.
There are different oracle versions for datapump like 11g,12c and 19c. All these versions will be used and their efficiency will be compared.
You will learn how to export a database,schema,table,index,constraint,view and query etc.. and import them to a database using different methods
You will learn how to speed up the export and import with different parameters and different approaches.
Prerequisites:
Oracle Database Administration fundamentals
Linux operating system basics
PC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit
CPU core(minimum) - 2
Student category:
Oracle DBA
For any questions, reach out to me at oracle community
Profile name- Kishan-Oracle