Note: Technical Talk being moved to:
www.nazimcricket.com/wiki


Monday, 24 October 2011

Export to Pipe

Using fifo (first in first out) you can redirect your database exports through a pipe straight to gzip.
make fifo pipe
mkdir fifo db.fifo

write the file output to gzip and send to background
cat db.fifo | gzip > db.dmp.gz &

run the export to the fifo pipe
exp username/password file=db.fifo log=db.log etc

Thursday, 13 October 2011

PeopleSoft SymbolicID

Note to self - symbolicid is stored in table:
PSACCESSPRFL