SHELL实现ORACLE大数据导出功能脚本如下:#!/bin/sh. /home/ecsman/.bash_profilesqlplus -S uqry***de_01/a**T7s@NPF ./USER.TXTset newpage 0set pagesize 0set linesize 0set head offset feedback offset tab offselect distinct(ff.Order_No) from order_gs ff;exitEOF说明:order_gs 表中有3千w数据,都要导出,我用以上脚本实现导出功能。[lces@BJ-XHM-3F02-LCHT-06 ftp]$ wc -l USER.TXT 32846499 USER.TXT