PL/SQL Developer Import and Export database method and illustrate

Source: Internet
Author: User
Tags prev

PL/SQL Developer Import and Export database method and illustrate how well does you KNOW the APPLE UNIVERSE?

In, Apple became the first company worth how much?

Which religion did Steve Jobs practice?

What is one of the Apple protects its secrecy?

In 1981, "Woz" is in a plane crash and suffered which effect?

Why does Steve Jobs leave his job designing video games at Atari?

Who is Apple's second biggest, after the states?

What is Tim Cook ' s position before he took over as Apple's CEO?

Who is not one of the original 1971 founders of Apple?

Despite the fact that he is the founder of the company, in 1985:

Woz made a guest appearance in which Big Bang theory episode?

14
    • $700 billion

    • $1 Trillion

    • over $ billion

    • $900 million

    • zen Buddhism

    • islam

    • judaism

    • Christianity

    • Accounts Require fingerprints to access

    • randomly fires employees

    • creates fake projects for employees

    • Li class= "cbola-d-trivia-multi__answer" data-answer-id= "25775" >

      Moves its location every 4 months

    • Loss Of he right arm

    • short term memory loss

    • limited movement in his jaw

    • Severe Migraines

    • To Fundraise for Apple

    • to travel through India

    • he fell in love with a married coworker

    • Li class= "cbola-d-trivia-multi__answer" data-answer-id= "25791" >

      Due To health reasons

    • Israel

    • Japan

    • canada

    • china

    • Secretary

    • Interior decorator

    • coo

    • Content Writer

    • Bill Gates

    • ronald Wayne

    • steve Wozniak

    • steve Jobs

    • Tim Cook called Apple "hopeless"

    • steve Jobs is fired from Apple

    • steve Wozniak sued Apple

    • Ronald Wayne Worked as a waiter

    • Pants Alternative

    • Cruciferous Vegetable Amplification

    • Dumpling Paradox

    • Bat Jar conjecture

START NEXT Quizyou scored A Fair 5/10challengeyour FRIENDS 

NEXT QUIZ starts in:

10Your score 0 Question 2/10 Add this Widget to Your Site 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, this mainly introduce how To use PL/SQL Developer import and Export database, and the import or export of some matters needing attention related ins Tructions.

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 are also very good, the most widely used.


The second is exported as. SQL files, use a text editor to view, versatility are good, but not as efficient as the first, suitable for small amount of Import and Export data. Particular attention is the table cannot has large fields (BLOB, CLOB, long), if any, would prompt cannot derive (tips are As follows:table contains one or more LONG columns cannot export in SQL Format,user/PL/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's 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

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.