2007/7/26, Niall Litchfield <niall.litchfield@xxxxxxxxx>: >but even then require > serializable transactions for reports more than a single select. Or one can use "as of SCN" or "as of timestamp" clause (flashback query). http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/consist.htm#CNCPT421 Gints Plivna http://www.gplivna.eu -- //www.freelists.org/webpage/oracle-l