Oracle error 1406, extracted column values are truncated

Source: Internet
Author: User

To back up the data, you need to export the complete data of 11 GB users on the server. The client on the machine is Oracle10g. Run the command: exp ***/*** @ *** file = ***. dmp full = y

After the command is executed, the system prompts:

EXP-00008: ORACLE error 1406

ORA-01406: extracted column values are truncated

EXP-00000: Export termination failed

I checked a number of materials, some said that the client and the server did not match, but the leaders said that the machine was used for backup in January. Then there were a lot of unheadned flies doing searches, and there was no way. Finally, the leader told him to export the written exp and asked me what full = y meant. At that time, it was not clear that this was to export all data objects under the instance where the current user is located. Sorry, you are ignorant! I only need to back up the data of the current user. Then we removed the full = y at the end, and added the owner = *** (the same as the previous one). Finally, we were able to see the backed up data tomorrow. Self-satisfied.

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.