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)amazon_ad_tag = “tilatequilaph-20″; amazon_ad_width = “300″; amazon_ad_height = “250″;

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$//’ [...]

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
*Set commands (UNION,etc) cannot [...]

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 that [...]