The UNIX and Linux Forums  


Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
.
google unix.com




Thread: splitting file
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #4 (permalink)  
Old 11-30-2005
rkl1 rkl1 is offline
Registered User
  
 

Join Date: Nov 2005
Posts: 6
Thanks

Guys,
thanks for all the help. It is not a home work although perfectly sounds that way. I have a long sql file which has many individual sql statements like analyze table (one liner). so what we want to do is to break the master script into 5 individual script so we could run 5 sqlplus sessions at a time. However it could be done with other way but this 5 sqlplus sessions is now the interest to my company.

I used stuffs like you guys mentioned: both sed and split:for example:

split -b1024b bigfile and it created a bunch of xxa xxb types which could be renamed to sql file and very well run without trouble.

sed was useful too.

thanks.