I was using this to see if we would gain any from compression, ctrl-c out of one processing and then could never run anymore due to BUG: 9151921 , INVALID COMPRESSION ...COMPAT SETTING. If you run into this(and I caused it by CTRL-C out of one already running, drop table sys.dbms_compression_temp_cmp; will fix it and then you can give it another whirl. joe _______________________________________ Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead (Work) 614-677-1668 (Cell) 614-312-6715