参考一下 set trimspool on set newpage none set linesize 120 set pagesize 0 set newpage 1 set heading off set term off set echo off set feedback off set trims on spool /result.txt select T.OWNER,T.TABLE_NAME from all_tables t where t.owner='SYSTEM'; spool off
将上面的文件保存成一个.SQL文件
直接在SQLPLUS里面执行以下 sqlplus masayj/masayj@DWDB_new << END @/保存.sql END
执行完成后会生成/result.txt
第3个回答 2011-02-21
exp username/password@servicename file=D:\*.dmp tables=(tablename) query=\" where filed= '?'\"追问