Originally posted by desmondliu
some one said option 2 performs better than option 1, but i have some doubts on it. this is the first question,
and another one, let's assume the problem is with the temp ts, if there are soring logic involved somewhere, will the option 2 better than option 1?
Over DB link, i wud prefer to have segment created and then use COPY cmd to copy data...rather than go for Select Insert or Create Select.

In that respect, i meant 2 betters.

But in ur scnerio..ur Tablespace ( target ) is unable to extend as its reached the size specifed during creation.
WRT this, u may have to add datafile, or use AUTOEXTEND with MAXSIZE limited.

If sorting logic is there, then there lies problem with ur TEMP tablespace defined for the USER, if its throwing error as to it cant extend space. It may have to be given some more sapce to do sorting.

Abhay.