Use PL/SQL developer to export table structures and Data

ClickTools -- Export user objects

In this way, all objects owned by the current user can be exported, including tables, views, triggers, synonyms, etc. For tables, only the table structure (Table creation statement) can be exported, and data cannot be exported,

Select the object to be exported, set the export path and parameters, and click Export.

PS: 1) This method can also export objects of other users. In the user drop-down box below, select the target user. By default, the current user is logged on to the system.

2) All files exported in this way are SQL statements for creating objects. Therefore, the exported file name is automatically added without the extension. SQL, or write XXX on the display. SQL, it is best not to write it in other formats, such as DMP, because the file is not in the DMP format and cannot be imported using imp

 

If you want to export data from a tableTools -- export tablesThe exported file contains the SQL statement used to create the table structure.

You can select multiple tables to export. There are three export methods:

Oracle export, SQL insert, PL/SQL developer

The first is the file format exported as. dmp. The. dmp file is binary and can be cross-platform and contain permissions, which is very efficient and widely used.

The second type is exported as a. SQL file, which can be viewed in a text editor and has good versatility, but is not as efficient as the first type. It is suitable for importing and exporting small data volumes. Note that there cannot be large fields (blob, clob) in the table. If so, you will be prompted not to export them. You can export them in the first and third ways.

Third, export. ,. you can only use PL/SQL developer to import and export files in the format of PL/SQL developer. You cannot use the editor to view the files.

 

PS: The table structure and index structure remain unchanged after the "Oracle export" method is used for export and re-import. The other two methods both change the index type.

 

The import is the same as the export.