Tuesday, October 1, 2024

Find a file under specific directories in UNIX

Use below command to find Filename under sub directories of $AP_TOP

find /$AP_TOP -name "Filename*" -print

 

Query to find the EBS Instance Refresh/Clone Date

 select name, creation_date from apps.FND_APPS_SYSTEM; SELECT resetlogs_time FROM   v$database;