unable to extend temp segment reached in creating as select statement

[jmodic]

If the sort-requiring oparetions listed above are used in your remote view, then the sorting will be done at remote database, hence remote temp tablespace will be used for that.