The script is divided into four parts:
EXP_MAIN.BAT:
SQLPlus
Scott / Tiger @ SDF154 @. / exp_table.sql
echo
UserID =
Scott / Tiger @ SDF154> YW_EXP.DAT
TYPE TABLE_NAME.TXT >> YW_EXP.DAT
Type loader.txt >> yw_exp.dat
Exp Parfile =. / yw_exp.dat
Exp_table.sql:
Set Head Off Feedback Off Termout OFF
Set linesize 120
Set PageSize 80
Spool d: /test/table_name.txt;
SELECT 'TABLES = DXSQ.' || TName from Tab Where Tabtype = 'Table'
Spool OFF;
EXIT;
Loader.txt:
Direct = n compress = n grants = y indexes = y rows = y buffer = 419430
Query = "where rown u <= 100" filesize = 20m file = (d: /test/1.dmp, d: /test/2.dmp, but: /test/3.dmp:) log = d: / test / EXP_LOGS.TXT
The purple part defines the number of records.
