Re: Export via pipe ksh script

From: Barb Baker <bbbaker_at_mho.com>
Date: Thu, 03 Jan 2002 19:02:10 -0800
Message-ID: <F001.003E689E.20020103183518@fatcity.com>

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.dmpdate exit
 

  tadent> more $HOME/scripts/imp_arc.par ##### #   imp_arc.par # parameter file to import arcdb schema # #####

  userid=username/password fromuser=scotttouser=scottindexes=y 
  grants=n rows=y commit=y ignore=y feedback=100000 
  buffer=4000000 

<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Thomas Jeff

  To: <A title=ORACLE-L_at_fatcity.com
  href="mailto:ORACLE-L_at_fatcity.com">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!
  <FONT face="Courier New"

  size=2>-------------------------------------------- <FONT 

  face="Courier New" size=2>Jeffery D Thomas <FONT face="Courier New"   size=2>DBA Thomson Information
  Services Thomson multimedia
  Inc.
  Email: <A

  href="mailto:thomasje_at_tce.com">thomasje_at_tce.com <FONT 
  face="Courier New" size=2>DBA Quickplace: <A target=_blank 
  href="http://gkmqp.tce.com/tis_dba">http://gkmqp.tce.com/tis_dba 

  <FONT face="Courier New"

  size=2>-------------------------------------------- <FONT 

  face="Courier New" size=2>  Received on Thu Jan 03 2002 - 21:02:10 CST