5.1 Using Data Workshop

Use Data Workshop to load and unload data to the database.

• About the Load Data and Unload Data Wizards
  Use the Load Data and Unload Data wizards to load and unload data to and from the database.
• About Importing, Exporting, Loading, and Unloading Data
  You have several options when copying data between Oracle databases or between an Oracle database and external files. Data copying is accomplished by exporting and importing data, and by unloading and loading data.
• Import, Export, Load, and Unload Options
  The Oracle Database and Oracle APEX provide several powerful options for importing, exporting, loading, and unloading data.
• Accessing the Load Data and Unload Data Wizards
  Access the Load Data or Unload Data wizards in SQL Workshop by clicking Utilities and then Data Workshop.
• Loading Data
  Use the Load Data Wizard to copy and paste or upload data.
• Unloading Data
  Use the Unload Data page to export the contents of a table to a text file or XML document.
• Loading Data From the Oracle Cloud (Autonomous Database Only)
  Load data from the Oracle Cloud using Object Store References. (This function is only available for Autonomous Database users.)