Oracle application questions

Question 28: why we run datapatch:

The datapatch utility will run the necessary apply scripts to load the modified SQL files into the database. Entires will be added to both DBA_REGISTRY_HISTORY and DBA_REGISTRY_SQLPATCH views automatically.

XXXXXX1> SELECT patch_id, status FROM dba_registry_sqlpatch;

   PATCH_ID STATUS

  22139226 SUCCESS

  21948354 SUCCESS

  20204035 SUCCESS

  22139226 SUCCESS

  30805558 END

  20204035 END

  31219939 END

  31113348 BEGIN

 

No comments: