If you are using oracle 9i, you can use the dbms_metadata package to do so.

If on 8i, check DBA_SNAPSHOTS FOR QUERY.

HTH
Badrinath