dbms_comp_advisor

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

Other related posts:

  • » dbms_comp_advisor - TESTAJ3