Oracle imp only imports data from one table

Source: Internet
Author: User

If the table already exists.

Http://www.itpub.net/thread-345521-1-1.html

--------------------------------------------------

I just want to import a table in the backup file

During the operation, all data in the table array is accidentally deleted. How to import the data in the original backup data into the array...

Write the Import Statement directly.
IMP user/pwd tables = table_name

The import failed because your table structure still exists.

The table structure exists. No? // I only deleted the data... I didn't delete the table... now I only want to export data...

I deleted the table and imported it again...
Only delete data. Only import data...

I don't know how to get it .....

Try imp ignore = y ...........

Ignore = y

Re: Try imp ignore = y ...........

Quote:
Initially released by Stephen
Ignore = y

This is a positive solution.
Check whether the original data conflicts with the data for Imp.

Let's take a look at the IMP help = y parameter.
If a table exists, you can only import data.

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.