Expdp-export report ora-01775: synonym loop chain reason

Source: Internet
Author: User

Using expdp to export data today, we found an error reporting ORA-01775, as shown below:

 

 

This is an error reported when exporting data on the server. Then, I tried it on my local machine and found that the data can be exported successfully. I searched the internet because

Cause of the synonym sys_export_schema_01: expdp automatically generates the table during the export process. If the operation is interrupted in the middle, the table will exist, this error will occur if you manually delete the table and keep the synonym. However, I found that the table does not exist or does not have the synonym. This is not the reason. Then, I deleted some of the synonyms of tables or views that I could not find, and again showed that the table or view could not be found. I guess some tables or views that support the export graph do not exist. Therefore, compared with your own database, we found that the following view is available on your local database, but not on the problematic server.

Database_export_objects
Datapump_object_connect
Datapump_pathmap
Datapump_paths
Datapump_remap_objects
Datapump_table_data
Dba_export_objects
P_update_rmeqp_thematic
Schema_export_objects
Tablespace_export_objects
Table_export_objects
Transportable_export_objects

Find the problem and solve it:

Recreate these views and then create synonyms. Run again, OK.

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.