rkusenet

You are wrong. Only implicit created temp tables are fragmented
automatically and that too with no log clause.

select ..
from ..
into temp tmp_table with no log ;

the above will be fragmented.

for ********ly created temp tables
create temp table tmp_table
(
....
) with no log ;

you must mention FRAGMENT BY ROUND ROBIN clause.

The easiest way, if possible of doing it is to create a blank
implicit table.

for e.g.

select ...
from ..
where 0=1
into temp tmp_table with no log ;

this will create the temp table with round robin fragmentation
but will put no rows where because the WHERE clause is 0=1.

Now you can add rows to this table.