Should I be using this to export the data using the SQL Developer 'Data Pump Export Wizard' connected as a DBA?

Question

I am trying to learn more about Oracle databases in my spare time. I have Oracle Enterprise available in a Docker Container. I am a developer rather than a DBA. I have plenty of experience with SQL Server.

I am trying to use the data pump feature. So far I have done this:

1. Created a user called dummy and created a table (Dummy.table1).
2. Added a few rows to table1.
3. Created a user called admin and given this user dba access.
4. Login to SQL Developer as admin and select: View/DBA.
5. Connect to my database and use Data Pump Export Wizard to create a dump file.
6. Generate a .sql file from the .dmp file.

I have tried all four options (Database; Tablespaces; Schemas and Tabeles) under: 'Types to be exported in data pump', selecting 'Data and DDL' each time, however I cannot see the INSERT statements, which should be created for Dummy.table1. Why is this?

The only thing I can think of is that there is a menu item called: Tools\Database Export. Should I be using this to export the data? I would of thought that the data should be exported when using the Data Pump Export Wizard; connected as a DBA?

Answer 1

Data Pump stores definitions and data in dumpfiles with a binary format specific to Oracle. Data Pump can be used to generate DDL SQL statements (create user, table, view, trigger, etc.), but not for the data in tables.

If you want INSERT statements, then yes, use the Database Export feature of SQL Developer instead of Data Pump.