How to export and import Oracle database tables and data separately

1. Export

Export with PLSQL

Export table structure:

Tools --> Export User Objects (Export User object) --> select the table to be exported (including Sequence and so on) -->. SQL file, all exported are SQL files

Export table data:

Tools --> Export Tables --> select a table and select SQL Inserts -->. SQL File

Import table structure:

Execute the exported SQL file. If the tablespace is different from the user name, modify it.

Import table data:

Execute the exported SQL File

2. Import

First create a user, and then use the command line to enter, execute start + file address such as: start d: \ XX. SQL