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:
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