Re: ** cache table

I'd go with the documentation. If you don't specifiy a value at create time the table is created NOCACHE. If you ALTER TABLE after the table is created (and when else would you "alter table") and you don't specifiy a value, then the existing value is unchanged.

--
http://www.freelists.org/webpage/oracle-l