EXP导出表脚本

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;