Would $ORACLE_HOME/rdbms/admin/dbfusrpt.sql be of any help? Looks to do what you want, almost. This is in 11g, not sure if it is available in 10g, i have no way to check. Raj -- //www.freelists.org/webpage/oracle-l