Quote:
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.