unable to extend temp segment reached in creating as select statement

[slimdave]

If you're creating the table in TS_A, and the temp tablespace is TS_B, and the error you get is that you can't extend the temp segment in TS_A, then the problem is not with sorting.

The new table is created as a temp segment, and when the insert is complete it is ocnverted to a table segment. I think you just don't have enough space in TS_A for the table.