Export Tables and Import Tables
Two wizards for moving table structure and data as a portable .sql file. Both are Oracle-only and open from Database → Export/Import Tables…, the toolbar, or the command palette.
#35.1Export Tables
Left — what to export
- Schema — defaults to your own.
- Filter tables… and the table checklist, with All / None links and a
selected / totalcounter.
Right — how to export
| Option | Choices |
|---|---|
| What to export | Structure + Data (default) · Structure only · Data only |
| Include objects | Constraints, Indexes, Triggers, Comments (all on by default), Grants (off). Disabled when exporting data only. |
| Where clause | An optional row filter applied to every exported table, e.g. department_id = 10. Disabled when exporting structure only. |
Export builds the script server-side (table DDL from the data dictionary plus INSERT statements) and downloads export_<SCHEMA>_<date>.sql. When it finishes you get a summary — how many tables, how many rows, how long — and any per-table errors are listed individually.
#35.2Import Tables
- Import file (.sql export) — choose a file produced by Export Tables.
- If a table already exists — five behaviours:
| Option | Behaviour |
|---|---|
| Skip existing tables | Existing tables are kept as-is; their CREATE statements are skipped. |
| Append data | Existing tables are kept; imported rows are added. |
| Truncate before import | ⚠️ Existing rows are removed before the imported rows are inserted. |
| Replace (drop & recreate) | ⚠️ Existing tables are dropped and recreated from the file. |
| Create only (fail if exists) | An error is reported when a table already exists. |
- Commit — a single transaction (commit at end), or every 100 / 1000 / 10 000 rows.
- Continue on error — on by default; the import keeps going past a failing statement.
Import runs the script and reports statements executed, rows inserted, skipped, failed and elapsed time. A per-table results table shows whether each table was Created or already Existed, the row count (with failed rows in brackets), and any error. Show execution log expands the full log.