What is the similar statement for 'alter tablespace temp default storage (pctincrease 1)' for Oracke 9.2 ? It worked for Oracle 8.1 to coalesce temporary tablespace. Thanks. --------------------------------- Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! -- //www.freelists.org/webpage/oracle-l