If you think a database link is not functioning properly, then you can drop and re-create it using Oracle Enterprise Manager Cloud Control, SQL*Plus, or another tool.
Ensure that the database link name is the same as the global name of the target database.
Ensure that the scheduled interval is what you want.
Ensure that the scheduled interval is not shorter than the required execution time.
If you used a connection qualifier in a database link to a given database, then the other databases that link to that database must have the same connection qualifier. For example, suppose you create a database link as follows:
CREATE DATABASE LINK dbs1.example.com@myethernet CONNECT TO myadmin IDENTIFIED BY password USING 'connect_string_myethernet';
复制
All the databases, whether master databases or materialized view databases, associated with dbs1.example.com@myethernet must include myethernet as the connection qualifier.
See Also:
"Using Connection Qualifiers to Specify Service Names Within Link Names" for more information database links and connection qualifiers
Parent topic: Troubleshooting Problems with Read-Only Materialized Views
