PL/SQLDeveloper how to import and export Oracle databases

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.