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.