Import dmp files to Oracle 11g

Source: Internet
Author: User

Execute: imp pg/pg imp username/password press enter in the command line to import the dmp file. Enter the import file path: EXPDAT. DMP> c: \. dmp input insert buffer size: by default, if this parameter is left blank, press enter only lists the content of the import file. Press enter to ignore the creation error: yes import permission: yes import table data: yes import the entire export file: yes, wait for... the import is terminated successfully, but a warning is displayed. For example, run 4.imp pg/pg @ pgfs110 imp username/password on the command line and press enter to enter the import file path: EXPDAT. DMP> c: \. dmp input insert buffer size: by default, if this parameter is left blank, press enter only lists the content of the import file. Press enter to ignore the creation error: yes import permission: yes import table data: yes import the entire export file: yes, wait... OK.

Related Article

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.