PL/SQL Developer import and export database method and illustrate

NEXT QUIZ STARTS IN:

PL/SQL Developer import and export database method and illustrate

PL/SQL Developer is one of the main tools to import or export database for the Oracle database, here mainly introduce how to use PL/SQL Developer import and export database, and the import or export of some matters needing attention related instructions.

1 export steps: 

1.1. tools ->Export user object options, export.Sql file

Description: export is built in table statement (including storage structure).

1.2. tools ->export tables-> Select the option to export.Dmp file Oracle Export

Description: contains three kinds of export, three can export the table structure and data, as follows:

Oracle Export

Sql Insert

PL/SQL Developer

The first is derived for the.Dmp file type, the.Dmp file is binary, cross platform, but also contains authority, efficiency is also very good, the most widely used .

The second is exported as.Sql files, use a text editor to view, versatility is good, but not as efficient as the first, suitable for small amount of import and export data. Particular attention is the table cannot have large fields (blob, CLOB, long), if any, will prompt cannot derive (tips are as follows: table contains one or more LONG columns cannot export in sql format,user Pl/sql developer format instead).

The third kind is derived for the.Pde type,.Pde Pl/sql developer own file type, with Pl/sql developer‘s own import and export only, cannot use the editor to view.

2 steps:

a.tools->import tables->SQL Inserts import.Sql files.

b. tools->import talbes->Oracle Import and then importing the DMP file.

Description: and the derived class like PL/SQL Developer, specific reference manual, in addition, it is best to the table before the delete imported before, of course except import another database.

PL/SQL Developer import and export database method and illustrate

标签：statement   addition   isl   ref   sla   ril   loss   crash   dump