Plsql Importing and exporting table data

export Table structure: tools (tool)-->export user Objects (Export users object)--Select the table to be exported (including sequence, etc.)-->.sql file, export to SQL file Export Table Data: Tools (tool)-->export Tables (export table)--Select table, select SQL Inserts (SQL Insert)-->.sql file Import Table Structure: Execute the SQL file just exported, remember to delete the user name before table, for example, this table named Sys.tablename, you must remove the SYS import table data: Execute the SQL file that you just exported: Click File-->open-->sql Script to import the existing SQL file, which will be displayed in the SQL window in the form of code, all selected, click on the Gear button on the left to execute.

Plsql Importing and exporting table data