The previous blog introduced how to use the Navicat tool to back up Oracle. This blog introduced how to use the PLSQLDeveloper tool to import and export Oracle databases. PLSQLDeveloper is one of the main tools used by Oracle databases to import and export databases. This article mainly introduces the process of using PLSQL to import and export Oracle databases. 1. Oracle count
The previous blog introduced how to use the Navicat tool to back up Oracle. This blog introduced how to use the PL/SQL Developer tool to import and export Oracle databases. PL/SQL Developer is one of the main tools used by Oracle databases to import and export databases. This article describes how to import and export Oracle databases using PL/SQL. 1. Oracle count
The previous blog introduced how to use the Navicat tool to back up Oracle. This blog introduced how to use the PL/SQL Developer tool to import and export Oracle databases.
PL/SQL Developer is one of the main tools used by Oracle databases to import and export databases. This article describes how to import and export Oracle databases using PL/SQL.
1. Oracle Database Export procedure
1.1 Tools → Export User Objects... option, Export the. SQL file.
Note: This step exports the table creation Statement (including the storage structure ).
1.2 Tools → Export Tables... Export table structure and data
The PL/SQL tool provides three methods to Export the structure and data of an Oracle table: Oracle Export, SQL Inserts, and PL/SQL Developer. The differences are as follows:
The first method is to export files in. dmp format. dmp is a binary file that can be used across platforms and contain permissions, which is efficient and most widely used.
The second method is to export files in. SQL format, which can be viewed in a text editor. This method is more universal and less efficient than the first method. It is suitable for importing and exporting small data volumes. Note that there cannot be large fields (blob, clob, long) in the table. If so, the system will prompt that the data cannot be exported (the prompt is as follows: table contains one or more LONG columns cannot export in SQL format, user Pl/SQL developer format instead ).
The third method is to export a file in. PVDF format, which is the file format of PL/SQL Developer. You can only use PL/SQL Developer to import and export files, but cannot use a text editor to view them.
2. Import steps (Tools → Import Tables ...)
Before importing data, it is best to delete the previous table, except for importing other database data.
2.1 Oracle Import
Import oracle files of the. dmp type.
2.2 SQL Inserts
Import oracle files of the. SQL type.
2.3 PL/SQL Developer
Import an oracle file of the. PVDF type.
The PL/SQL Developer tool can be used to import and export Oracle databases. If you have any problems, you can search the PL/SQL Developer operation manual or search and solve the problems.