PL/SQL import/export table structure, table data

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 and remember to delete the username before the table. For example, if the table name is sys. tablename, you must delete sys.

Import table data:

Execute the exported SQL File