PeopleSoft Questions
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page PeopleSoft Questions
| Line 8: | Line 8: | ||
================================================================================================= | ================================================================================================= | ||
| - | Q: | + | Q: How do I find out when a database was refreshed? |
Reply: | Reply: | ||
| + | In Oracle, you determine when the database was created with: | ||
| + | |||
| + | select name,created from v$database; | ||
| + | |||
| + | Not a perfect method, but the last day the database was Production will be the last day there was a large amount of activity: | ||
| + | |||
| + | select trunc(audit_stamp),count(*) from psaudit group by trunc(audit_stamp); | ||
| + | |||
================================================================================================= | ================================================================================================= | ||
