thank. however, should the sorting for the view been done in remote database? will it ask for temporary tablespace in local database? if split the create as select statement into two steps (1) create empty table (2) insert into xxx (select * from view@xxx). will it be better in terms of the usage of temporary ts?