Re: Backup and Retention Period

2005-03-08 Thread Andrew Raibeck
Your question relates not just to active and expired versions, but also to inactive versions that are not expired (depending on the number of versions you keep). For active backup versions: - the STATE column is ACTIVE_VERSION - the DEACTIVATE_DATE is null For inactive (but not expired) versions:

Backup and Retention Period

2005-03-07 Thread Norita binti Hassan
Hi , When I do a select statement q * from backups, it lists all the backup although some of them has been expired. How do I know, which is the active backup and which one has been expired. Thanks NORITA BINTI HASAN Senior Programmer Enterprise Systems Services Information Communication Tech.Di