Export and Import of table structures and table data in PL/SQL Developer, and tables in developer

Export and Import of table structures and table data in PL/SQL Developer, and tables in developer
Export table structure: Tools --> Export User Objects (Export User object) --> select the table to Export (including Sequence) -->. in the SQL file, all the exported table data is exported to the SQL file: Tools --> Export Tables (Export table) --> select a table and select SQL Inserts (SQL insert) -->. SQL File

Import table structure: Execute the SQL file you just exported and remember to delete the username before the table. For example, if the table name is sys. tablename, you must delete the sys import table data: Execute the SQL file you just exported.


Export table structure and table data: Tools --> Export Tables (Export table) --> select table, select SQL Inserts (SQL insert), and check box of create tables -->. SQL File

Import table structure and table data: Execute the exported SQL File