setline 500
sethead off
setfeedback off
setpagesize 0
columnexpfile format a500
select'exp gistar/gistar buffer=65535000 direct=y recordlength=65535 indexes=noconstraints=no triggers=no file='||segment_name||'.dmplog='||segment_name||'.log tables='||segment_name as expfile
from(select segment_name from (select segment_name,sum(bytes)/1024/1024/1024 as sfrom dba_segments where segment_type like 'TABLE%' and owner in ('GISTAR','GDOSYS','TJDDN','NMSDATA','MINGTIAN') group by segment_name order by s desc) a) b;