> > > Having quotas on a tablespace won?t prevent him from dropping > it. Those quotas will just go away. > No. They won't go away - they'll persist in the data dictionary and will take effect later if a tablespace with the same name is created again. And it cannot be removed as long as no tablespace with this name exists. regards kf -- //www.freelists.org/webpage/oracle-l