1)数据导出方式1
vi /testdata/data/liyg/export.sql
set echo off
set feedback off
set newpage none
set verify off
set pagesize 0
set term off
set trims on
set linesize 600
set heading off
set timing off
set numwidth 38
SPOOL /testdata/data/liyg/t71_recommend.txt
select t71recommend || ' ' || pid from aaaaaa;
SPOOL OFF
sqlplus / as sysdba
@ /testdata/data/liyg/export.sql
2)数据导出方式二
./sqluldr2_linux64_10204.bin safe=yes user=useaaa/******@ip/orcl query="select t71recommend,pid from aaaa; " log="/testdata/data/expdata/aaaaa.log" field=\t ncharset="CHINESE_CHINA.ZHS16GBK" charset="UTF8" file="/testdata/data/expdata/aaaaa.txt"
vi /testdata/data/liyg/export.sql
set echo off
set feedback off
set newpage none
set verify off
set pagesize 0
set term off
set trims on
set linesize 600
set heading off
set timing off
set numwidth 38
SPOOL /testdata/data/liyg/t71_recommend.txt
select t71recommend || ' ' || pid from aaaaaa;
SPOOL OFF
sqlplus / as sysdba
@ /testdata/data/liyg/export.sql
2)数据导出方式二
./sqluldr2_linux64_10204.bin safe=yes user=useaaa/******@ip/orcl query="select t71recommend,pid from aaaa; " log="/testdata/data/expdata/aaaaa.log" field=\t ncharset="CHINESE_CHINA.ZHS16GBK" charset="UTF8" file="/testdata/data/expdata/aaaaa.txt"