How to check snapshot information


Excute this command as an apps user

SQL> select aat.NAME,asn.CREATION_DATE,asn.LAST_UPDATE_DATE, asn.RAN_SNAPSHOT_FLAG  FROM APPS.AD_SNAPSHOTS asn,
APPS.AD_APPL_TOPS aat WHERE asn.APPL_TOP_ID = aat.APPL_TOP_ID
AND asn.SNAPSHOT_TYPE = ‘C’;


Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."

Comments

  1. I just couldn’t leave your website prior to suggesting that I extremely loved the usual info a person provide for your guests? Is gonna be again regularly in order to check up on new posts