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
Read More mutt email attachmentMake 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