Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: wildcard in imp73.exe

Re: wildcard in imp73.exe

From: Rich Woods <rawoods_at_concentric.net>
Date: 1997/04/20
Message-ID: <335A885F.5D62@concentric.net>#1/1

sharon Viente wrote:
>
> Hello,
>
> 1. Could somone tell me how to export and then import from two Oracle7
> servers (Unix to NT) more than one table at a time . I am using
> exp73.exe?.
> My tabless have the same preffix so i need wildcard expression (something
> like exp73 myfile_*).
> 2. Is there another way of copying files from one server to the other if
> they are on the same network.
>
> Sharon.

1) You can specify multiple tables with the TABLES=(..., ..., ... ) keyword.
2) If you mean tables instead of files, how about an Insert into a local table driven by a Select from a remote table.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Received on Sun Apr 20 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US