Importing & Exporting Data

Oracle 12c    |    Intermediate
  • 11 videos | 48m 18s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 27 users Rating 4.5 of 27 users (27)
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

  • Locked
    1.  Data Migration and Oracle Data Pump
    6m 39s
    After 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
  • Locked
    2.  Oracle Data Pump Directory Objects and Clients
    5m 27s
    During this video, you will learn how to work with Oracle Data Pump directory objects, clients, and modes in Oracle Database 12c. FREE ACCESS
  • Locked
    3.  Exporting Data with Data Pump
    2m 34s
    In this video, you will learn how to export data using Data Pump in Oracle Database 12c. FREE ACCESS
  • Locked
    4.  Importing Data with Data Pump
    3m 48s
    In this video, you will learn how to import data using Data Pump in Oracle Database 12c. FREE ACCESS
  • Locked
    5.  Creating a SQL*Loader Control File
    6m 19s
    Learn how to create a SQL*Loader control file in Oracle Database 12c. FREE ACCESS
  • Locked
    6.  Using SQL*Loader to Load Data
    5m 16s
    In this video, find out how to use SQL*Loader to load external data into tables in Oracle Database 12c. FREE ACCESS
  • Locked
    7.  Using External Tables
    3m 21s
    After completing this video, you will be able to describe the uses of external tables in Oracle Database 12c. FREE ACCESS
  • Locked
    8.  Accessing External Tables
    2m 27s
    During this video, you will learn how to use ORACLE_LOADER to access external tables in Oracle Database 12c. FREE ACCESS
  • Locked
    9.  Populating External Tables
    3m 12s
    In this video, you will create and populate an external table using ORACLE_DATAPUMP in Oracle Database 12c. FREE ACCESS
  • Locked
    10.  Using Data Dictionary Views for External Tables
    3m 18s
    To find out how to use data dictionary views to access information about external tables in Oracle Database 12c, consult the Oracle documentation. FREE ACCESS
  • Locked
    11.  Exercise: Back up Database and Export HR Schema
    5m 58s
    In 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.

YOU MIGHT ALSO LIKE

Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Channel Oracle RAC
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.7 of 30 users Rating 4.7 of 30 users (30)
Rating 2.9 of 11 users Rating 2.9 of 11 users (11)
Rating 4.7 of 13 users Rating 4.7 of 13 users (13)