drop database ... is there in 10g, perhaps they had its usefulness as an answer to opaque questions in mind. It would take Carel-Jan's excellent comment about never executing the statement to a more appropriate level, that of never executing any statement. Performance heaven. On Wed, 16 Mar 2005 00:54:56 -0000, Tanel P=F5der <tanel.poder.003@xxxxxxx>= wrote: > Someone should file an enhancement request for "truncate database" comman= d, > this would not only be faster, but also more automatic! Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com -- //www.freelists.org/webpage/oracle-l