Re: Exporting multiple files using exp73.exe

From: Gary M. Greenberg <garyg_at_southeast.net>
Date: 1997/04/26
Message-ID: <5jtgnn$78b@news.southeast.net>#1/1

Forgive me; I missed the original thread, but I think I've got the Q&A's sorted out:

> > > 1. Could somone tell me how to export and then import from two
 Oracle7
> > > servers (Unix to NT) more than one file at a time . I am using
 exp73.exe?.
> > > My files have the same preffix so i need wildcard expression
 (something
> > > like exp73 myfile_*).

I would do it in a shell script as (untested pseudocode, excuse the typos):

#!/bin/sh -f
if [ $# -eq 0 ] ; then

        echo "Usage: $0 <files.ext>"
        echo "         or
                             $0 <*.ext>"
        exit

fi
for i in $*
do

        out=`echo $i | sed 's/ext//'`
        $ORACLE_HOME/bin/exp $i ... <export syntax> ...  $out.dmp

done

> > > 2. Is there another way of moving the file from one server to the
> > other
> > if
> > > they are on the same network.
> > >
> > > Sharon.

either ftp with bin, prompt && mget *.dmp (prompt will turn off request for verification) or Get Samba so that the NT machine can see your unix drives.

> > don't know of a way to connect drives between NT and UNIX.
>

SAMBA.

gary         -=-  The C Programmers' Reference -=-
        http://users.southeast.net/~garyg/C_ref/C/c.html
        -=-    Avenue Programmers' Classes' Requests -=-
         http://users.southeast.net/~garyg/classes.htm

Received on Sat Apr 26 1997 - 00:00:00 CDT