Originally posted by sreddy
There are some problems in Using LMTs for TEMP...So I create LMTs only for DATA and INDEX but not TEMP. Anyway LMTs do not support SYSTEM & RBS...

Yeah! Query depends on TEMP tablespace. Say for example If your query is trying SORT and your SORT_AREA_SIZE is limited it has to use TEMP tablespace for sorting and it can't extend for the space needed you get ORA-1652 error..
and how harmful is this error for the database and what what will happen to the statement which triggered it.

sreddy can you please let us know about the issues with Temo LMT because I recently changed all my TEMP's to LMT's from Dictionary managed.

Also I have a couple of databases where RBS is LMT and they alsi seem to be working fine. Any thing which I should look for...

Thanks