mutt email attachment

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

Read More mutt email attachment
July 30, 2010

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) ) ; create index af1 on af ( mycol ) ; alter index af1 unusable ; insert […]

Read More Make indexes unusable before big insert
July 30, 2010