Pl/sql Developer is the primary tool for importing or exporting databases in an Oracle database, this article mainly introduces the process of importing and exporting databases using Pl/sql developer, and describes some of the considerations when importing or exporting, and then we introduce them.
Export Step:
1 Tools->export The User Object selection option to export the. sql file.
2 Tools->export tables-> Oracle export Selection option exports. dmp files.
Import Step:
Note: It is a good idea to delete the previous table before importing, except to import another database.
1 tools->import tables->sql inserts import. SQL file.
2 tools->import talbes->oracle Import and then imports DMP file.
Some notes:
Tools->export User Objects exports the build table statement, including the storage structure.
Tools->export tables contain three ways to export, three ways to export the table structure and data, as follows:
Oracle Export
SQL Insert
Pl/sql Developer
First Kindis exported to. dmp file format,. dmp file is binary, can cross-platform, also can include permissions, efficiency is very good, the most widely used.
Second Kindis exported as a. sql file, available as a text editor, it's better to be generic, but less efficient than the first, for small data import and export. It is particularly important to note that the table cannot have large characters (Blob,clob,long) and, if so, prompts that it cannot be exported (prompted as follows: table contains one or more long columns cannot export in SQL Format,user Pl/sql developer format instead).
Third Kindis exported to. pde format,. PDE is pl/sql developer own file format, can only be imported with Pl/sql developer, can not be viewed with the editor.