I am not clear of what you are trying to say. Are you saying that I should use TEMP tablespace with LOCAL EXTENT??? what about ROLLBACK tablespace ???

thanks