List, How to get current SCN number other than using dbms_flashback package. Thanks for your advice. Thanks Prabhu. _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/