#!/bin/ksh
# name partn_exp.sh
# version 0.0
# description Interpreted shell script to zip
# an Oracle export of large tables
# synopsis No arguments
# usage From the shell prompt:
# $ ./generic_exp.sh
# comments
# copyright
# creation 06 JUL 2006
# author D. Clement
# warranty None expressed or implied
# changes 29 SEP 2006 D. Clement Rewrote
read UNAM?"Enter the table owner name -> "
read UPWD?"Enter the table owner's password -> "
read OSID?"Enter the SID -> "
rm -f xpipe
/usr/sbin/mknod xpipe p
chmod g+w xpipe
nohup gzip < xpipe > generic_exp.gz &
nohup exp $UNAM/$UPWD@$OSID parfile=generic_exp.par 2>&1 &