Export Database

The Export Database function enables you to export certain data tables from the database. The export function only exports table, data, index, and trigger and does not export the view or sequence.

1. In the Tools Import/Export tab, select Export Database from the ribbon bar.

2. In the Export Database window, enter the 16–digits Encryption Key for the dump file.

3. Select the table to export individually or click Select All at the ribbon bar for all tables.

4. Click Backup on the ribbon bar to compress and encrypt the data table. The system prompts ‘File had been backup to ‘C:\<FilePath>\<Filename>’ when the export is ready.

   If Transparent Data Encryption (TDE) applies, the backup file is stored as DATA_PUMP_DIR in the Oracle Database directory instead. You are prompted to enter the DMP Password and Filename.

5. Click OK to confirm and close the window.