Originally posted by Raj Kishore
Put the AUTOEXTEND ON of your targeted tablespace datafile.
DO u mean, have autoextend ON and no max size?

That wud be dumb idea..of not letting TEMP tablespace to grow without limit.


some one said it is better if we split the above up into 2 parts, with
(1) create an empty table
(2) then, insert data into the created empty table,

Is it true that by doing this can solve the problem? any reasoning behind this?
You solution/suggestion/comments will be highly appreciated.

Rgds
Desmond
Better idea. AS creating empty table will not require TEMP TS.
and also inserting data ( bulk insert select ) will not as well.

Abhay.