Export Selected Tables (Schema + Data)

  1. Open Oracle SQL Developer
  2. Connect to your target database
  3. Go to Tools -- Database Export
    Database Export
  4. In the Export Wizard,
    • Connection: Choose your database
    • Export DDL: Tick is Enabled
    • Export Data: Tick is Enabled
    • Object Types: Select Tables
    • Click the edit icon (pencil) to choose specific tables manually
    • Check theTick Export DDL and Export Data
      Export DDL
    • Under the standard Object Type Tick, which one is required to choose, like Tick Tables, Procedure, etc.
      Object Type
    • Based on the Table and Procedure, select and double click it will be listed on the right side content added.
      Table and Procedure
      Specify object
    • You Can See the Table (tables icon) and Procedure like (Procedure icon)
      Procedure icon
      Data
  5. Choose
    • Format: SQL
    • Output File: Save to .sql
  6. Click Next -- Finish

This creates a script with,

Finish

  • CREATE TABLE statements
  • INSERT INTO statements for each selected table