Oracle Export Data compression

oracle| Export Data | compression
Mybat.bat
Sqlplus-s A/a@mydb @d:\a\mysql.sql

Mysql.sql

Set time off echo off head--This row setting does not count the Times does not show the SQL statement not every few lines present column name
Set pagesize 0--Remove blank lines or extra spaces without a grid
Set trims on--Remove all spaces, default length not enough padding spaces
Set feedback off--does not display the number of selected rows cannot be with the previous row and together
Spool D:\a\aa1.txt--Output
Select Tname| | | | tabtype| | | |      Clusterid from Tab; --Content
Spool off--stop output
Host D:\rar.exe a D:\A\AA1 d:\a\aa1.txt--Compression
Spool D:\a\aa2.txt
Select Tname| | | | tabtype| | | | Clusterid from Tab;
Spool off
Host D:\a\rar.exe a D:\a\aa2 d:\a\aa2.txt
Host D:\a\rar.exe a D:\A\YSWJ d:\a\*.txt
Host D:\a\rar.exe e-o+ D:\a\yswj.rar * d:\a\a\-Extract files, overwriting if repeated
Host del D:\a\a\aa1.txt--delete files

Test files are all placed in the D:\a\ directory for mysql.sql files and Rar.exe files