Re: Export via pipe ksh script

[Barb Baker]

Title: Export via pipe ksh script

Here's one:   #!/bin/ksh # # ********************************************************** # /etc/mknod /u14/ORA_DUMP/arc_tadrcv.dmp p compress < /u14/ORA_DUMP/arc_tadrcv.dmp > /u14/ORA_DUMP/arc_tadrcv.dmp.Z & exp parfile=$HOME/exp_arc_tadrcv.par file=/u14/ORA_DUMP/arc_tadrcv.dmp log=arc_tadrcv.log rm /u14/ORA_DUMP/arc_tadrcv.dmp exit tadent> more $HOME/exp_arc_tadrcv.par ##### # exp_arc.par # parameter file to export arcdb schema ##### userid=username/password grants=y  indexes=y  direct=y compress=n rows=y  constraints=y  buffer=400000     ===========================================   #!/bin/ksh # # ********************************************************* # date /etc/mknod /u14/ORA_DUMP/imp_pipe.dmp p uncompress < /u14/ORA_DUMP/arc_exp.dmp.Z > /u14/ORA_DUMP/imp_pipe.dmp & imp parfile=$HOME/scripts/imp_arc.par file=/u14/ORA_DUMP/imp_pipe.dmp log=imp_arc.log rm /u14/ORA_DUMP/imp_pipe.dmp date exit   tadent> more $HOME/scripts/imp_arc.par ##### # imp_arc.par # parameter file to import arcdb schema # ##### userid=username/password fromuser=scott touser=scott indexes=y grants=n rows=y commit=y ignore=y feedback=100000 buffer=4000000 ----- Original Message ----- From: Thomas Jeff To: Multiple recipients of list ORACLE-L Sent: Thursday, January 03, 2002 5:35 PM Subject: Export via pipe ksh script Could someone please send me a ksh script for doing imp/exp via a pipe. We're running AIX 4.3.3.    Thanks! -------------------------------------------- Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba --------------------------------------------