Archive for March, 2007

FIND – one liners

find . -name “PLW_TCPIN*” -exec grep -l “$1” {} \; (finds file & string in file)find . -name “*core*” | xargs ls -l (finds cores and their sizes)find . -size +100000 -print (find files over 1 gig) To Rename all .jpeg to .jpg: for file in *.jpeg; do mv “$file” “${file%.jpeg}.jpg”; done

SED – one liners

sed G sed ‘s/.$//’ # assumes that all lines end with CR/LF sed ‘s/^M$//’ # in bash/tcsh, press Ctrl-V then Ctrl-M sed ‘s/\x0D$//’ # gsed 3.02.80, but top script is easier sed “s/\r//” infile >outfile # UnxUtils sed v4.0.7 or higher sed ‘s/^[ \t]*//’ # see note on ‘\t’ at end of file sed ‘s/foo/bar/’ […]

SQLLDR/Spooling

Miscellaneous issues when upload/downloading from Oracle. SPOOLING:When downloading/Spooling, large fields (Clobs/Memo) were being truncated. Had to SQL>Show all. Linesize,long,longchunksize were defaulting to 80-increased these. SQLLDR:sqlldr scott/tiger@LAWSON2 log=log.txt control=loader.ctl [loader.ctl]load datainfile ‘c:\merged.dat’into table seebeyond.RAD_MESSAGES_LDRfields terminated by “abcZ123” optionally enclosed by “”(MESSAGES CHAR(100000)) *To create One table from another: CREATE TABLE ZZZ AS SELECT * FROM AAA […]

Message from Sun Microsystems

Subject: IMPORTANT: New Email Address for Java CAPS Support Dear valued customer,We would like to take this time to inform you that we are disabling some of our old SeeBeyond email addresses. We ask that you no longer send Support emails to support@seebeyond.com or SeeBeyond-PoweringeBusinesses2@SeeBeyond.com. These addresses will be disabled effective March 31, 2007.We recommend […]



Subscribe for the latest posts, free promotions, and insider deals!!!