PL/SQL Developer Export data scripts, data

If you export only the structure of the table (build table statement), do not export the table data, you can tools--export User Objects

Select the table you want to export, set the exported path and parameters, click Export to OK

PS: This method can only export tables belonging to this user, other users of the table can not be exported, it is recommended to export with the command line (exp, IMP)

If you want to export all of the table structure, table data, triggers, functions and so on, you can use Tools--export Tables

Select the tables you want to export (more than one), there are three ways to export them:

Oracle export,sql insert,pl/sql Developer
The first is the file format exported to. DMP, which is binary, can be cross-platform, can also contain permissions, and is also very efficient, most widely used

The second is exported as. sql files, can be viewed with a text editor, versatility is better, but less efficient than the first, suitable for small data import and export. In particular, it is important to note that there can be no large number of fields (BLOB,CLOB) in the table, and if you do, you will be prompted not to export, which is the first and third way to export.

The third type is exported to. Pde format, the. PDE is PL/SQL developer own file format, can only be imported and exported by PL/SQL developer; can't use the editor to view, efficiency don't know how

PS: Only the "Oracle export" method is exported and then imported, the table structure and the index structure have not changed, and two different ways have changed the index type.

The import situation is the same as exporting

1. Complete export of the entire database table structure that is the DMP file method:
Tools-->export Tables, select the Oracle Export default option to select an output target
Export table structure by clicking Export

2. Export the data in the table:
Tools-->export Tables: Select SQL Inserts encountered large large segment (CLOB,BLOB) will not lead to the problem, where you can
Select the table you want to export, select the exported target in the output file, click Export and there are several options
You can remove all options to export directly.

3. Export database-building table scripts for all or selected tables in the database:
Tools-->export User Objects Remove the following three include * options, select Single file) in the output file
Select the output target and click Export

PL/SQL Developer Export data scripts, data