Importing & Exporting Data
Oracle 12c
| Intermediate
- 11 videos | 48m 18s
- Includes Assessment
- Earns a Badge
An Oracle database administrator is responsible for ensuring data is secure and available. Explore working with Oracle data, including data migration, the Oracle Data Pump, SQL*Loader files, and external tables.
WHAT YOU WILL LEARN
-
Describe the functional components used for moving data and the use of oracle data pump in oracle database 12c
Work with oracle data pump directory objects, clients, and modes in oracle database 12c
Export data using data pump in oracle database 12c
Import data using data pump in oracle database 12c
Create a sql*loader control file in oracle database 12c
Use sql*loader to load external data into tables in oracle database 12c -
Describe the uses of external tables in oracle database 12c
Use oracle_loader to access external tables in oracle database 12c
Create and populate an external table using oracle_datapump in oracle database 12c
Use data dictionary views to access information about external tables in oracle database 12c
Verify database configuration and export the hr schema in the oracle database 12c
IN THIS COURSE
-
1. Data Migration and Oracle Data Pump6m 39sAfter completing this video, you will be able to describe the functional components used for moving data and the use of Oracle Data Pump in Oracle Database 12c. FREE ACCESS
-
2. Oracle Data Pump Directory Objects and Clients5m 27sDuring this video, you will learn how to work with Oracle Data Pump directory objects, clients, and modes in Oracle Database 12c. FREE ACCESS
-
3. Exporting Data with Data Pump2m 34sIn this video, you will learn how to export data using Data Pump in Oracle Database 12c. FREE ACCESS
-
4. Importing Data with Data Pump3m 48sIn this video, you will learn how to import data using Data Pump in Oracle Database 12c. FREE ACCESS
-
5. Creating a SQL*Loader Control File6m 19sLearn how to create a SQL*Loader control file in Oracle Database 12c. FREE ACCESS
-
6. Using SQL*Loader to Load Data5m 16sIn this video, find out how to use SQL*Loader to load external data into tables in Oracle Database 12c. FREE ACCESS
-
7. Using External Tables3m 21sAfter completing this video, you will be able to describe the uses of external tables in Oracle Database 12c. FREE ACCESS
-
8. Accessing External Tables2m 27sDuring this video, you will learn how to use ORACLE_LOADER to access external tables in Oracle Database 12c. FREE ACCESS
-
9. Populating External Tables3m 12sIn this video, you will create and populate an external table using ORACLE_DATAPUMP in Oracle Database 12c. FREE ACCESS
-
10. Using Data Dictionary Views for External Tables3m 18sTo find out how to use data dictionary views to access information about external tables in Oracle Database 12c, consult the Oracle documentation. FREE ACCESS
-
11. Exercise: Back up Database and Export HR Schema5m 58sIn this video, you will verify database configuration and export the HR schema in the Oracle Database 12c. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
