Oracle database utilities Perform data export Import
What you’ll learn
Learn how to import csv data into oracle database using SQL Loader
Perform table. schema level exports using traditional Export Import utility
Perform table, schema level imports using traditional Export Import utility
Perform import export of tables and schema using Oracle Data Pump
Requirements
You must be an Oracle DBA
You should know basic database administration
Description
Master oracle utilities with very simple practice exercise which helps you to move data between two oracle databases. Learn how to use oracle utilities to perform data import export into different databases.
Perform entire database, single table or schema level export and import into another Oracle database
Perform table, schema, row level export using traditional Export Import utilityPerform table, schema,row level import using traditional Export Import utilityPerform CSV file import into Oracle database using SLQ * LoaderPerform table, schema, row level export using Oracle Data Pump Export utilityPerform table, schema, row level import using Oracle Data Pump Import utilityCreate Oracle Data Pump directory to perform Export and Import
Oracle Data Pump enables very high speed data movement from one database to another
In general, DBA has to perform data Export and Import in real-time environment in order duplicate table or schema from one database to another. Oracle provides utilities in order to easily move data between two oracle databases.
With over 9 lectures, 6 hands on lab activities and 1.5 hrs of video content, you will learn:
How to invoke oracle utilitiesHow to get help for any type of oracle utilitiesHow to import a CSV format file inside Oracle database tableHow to create SQL * Loader Control File for CSV importHow to perform a small table, schema or specific row export using Export Import utilityHow to perform import of same using Export Import utilityHow to create Data Pump directory both at OS level and Database levelHow to perform data Export and Import using high performance Data pump utility
By completing Lab Activities, you will be able to work along with the author and learn Oracle Utilities. You can even download lab activities files and practice on your test machine at home.
Overview
Section 1: Oracle Utilities
Lecture 1 Before you start
Lecture 2 Introduction
Lecture 3 SQL * loader
Lecture 4 Lab Activity – Import csv to Database Table
Lecture 5 Oracle Export Import
Lecture 6 Lab Activity – Performing Export
Lecture 7 Lab Activity – Performing Import
Lecture 8 Oracle Data Pump
Lecture 9 Lab Activity – Create Data Pump Directory
Lecture 10 Lab Activity – Performing Data Pump Export
Lecture 11 Lab Activity – Performing Data Pump Import
Section 2: Summary
Lecture 12 Bonus Lecture: Oracle RMAN advance backups
Oracle DBA – Any DBA who would like to learn Oracle Utilities,Oracle Developers – who would like to know how data is exported and imported,Others – Understand how oracle utilities work
Course Information:
Udemy | English | 1h 30m | 1.02 GB
Created by: Arun Kumar
You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com