Dblink update failure
Oracle database 10 g. I met a problem, the program has a use dblink to update the remote database statements, suddenly found a recent documents didn't update, in fact the two databases are within a local area network (LAN), how to check the update of what are the exception? Like sqlcode when users do documents without error, when using the select * from v $SQL to find the update statement which columns represent execution? Or how to look up at the time of oracle logs, found out the specific reason? And dblink exist not break? How to check what time off?

CodePudding user response:

up suddenly found a recent documents didn't update

Best way is to check the program of the log, not to consider the first v $SQL views, or network interruption,

CodePudding user response:

The more troublesome, may need to go to the object library, dba_hist_sqltext see if there are any,
Database records have execute the statement, however, as for if not successful, the relevant database is not an error, you need to record in the application log