Get Multiple User-Selected Table & Procedure Scripts in Oracle (Schema + Data)

Export Selected Tables (Schema + Data)

1. Open Oracle SQL Developer
2. Connect to your target database
3. Go to Tools -- 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
     
   • Under the standard Object Type Tick, which one is required to choose, like Tick Tables, Procedure, etc.
     
   • Based on the Table and Procedure, select and double click it will be listed on the right side content added.
     
     
   • You Can See the Table (tables icon) and Procedure like (Procedure icon)
     
     
5. Choose
   • Format: SQL
   • Output File: Save to .sql
6. Click Next -- Finish

This creates a script with,

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