脚本-create dd backup script

 select ts.name tsname,'!dd if='||df.name||' of=${BACKDIR}/'
     ||substr(df.name,instr(df.name,'/',-1) + 1)||' bs='
     ||((df.blocks + 1)*(df.bytes/df.blocks/1024))
     ||'k count=1'
  from v$datafile df,v$tablespace ts
  where ts.ts# not in (select distinct ts# from v$tempfile)
    and df.ts# = ts.ts#
    order by 1
/