From the course: Oracle HeatWave MySQL Foundations

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Unloading data

Unloading data

From the course: Oracle HeatWave MySQL Foundations

Start my 1-month free trial Buy for my team

Unloading data

“

(bright music) - [Instructor] Welcome to this lesson on unloading data from HeatWave cluster. It explains how to unload data manually and how to unload data by invoking the auto unload utility. Tables can be unloaded from the HeatWave cluster. For each table that you want to unload from the HeatWave cluster, run the ALTER TABLE statement with the SECONDARY_UNLOAD option. It removes the data from the HeatWave cluster and frees up the memory of the HeatWave nodes. The data in the database system is not affected. After unloading the data of a table, you can remove the rapid secondary engine from the table. For each table, run the ALTER TABLE statement with the SECONDARY_ENGINE = NULL. This removes the rapid secondary engine from the table. It prevents the table from being loaded into the HeatWave cluster. The data in the database system is not affected. Unloading multiple tables from HeatWave cluster can be a tedious task. The auto unload utility automates and simplifies the steps. It…

Contents