Monthly Archives: July 2010

mutt email attachment

Send email from unix with attachment, which in this case has been zipped with a password: zip -P mypassword /tmp/myfile.zip myfile.csv mutt -a /tmp/myfile.zip -s “Zipfile Attached” user@email.com < /dev/null

Posted in Email

Make indexes unusable before big insert

Make indexes unusable before doing a big insert, then rebuild them at the end, is faster than insert with indexes in place and no risk of forgetting to recreate a dropped index: create table af ( mycol varchar2(100) ) ;

Posted in Scripts