Re: EXporting lots of tables

From: Amit Srivastava <amit_at_miller.cs.uwm.edu>
Date: 1995/04/13
Message-ID: <3mk95p$el_at_uwm.edu>#1/1


You can specify a file with export which will read all the export requirements. In it you can specify a field called: tables=table1 table2 ... tablen
and then call export as:
exp FILE=exp.tables

You can also specify in htat file things such as passwords,buffersize,indexes.. etc. Lookup your rdbms utilities manual.

In article <797804393snz_at_minarama.demon.co.uk> mark_at_minarama.demon.co.uk writes:
>Looking at the docs for Export you can specify a tablelist but it seems only
>from the CLI.
>
>I want to export a subset of tables from a schema but I suspect that VAXEN
>have a 512 limit on the supplied CLI and my list will probably exceed that.
>
>A batch job will take care of things if a full-scale export must be; but I'm
>looking for something a tad more elegant. I've tried specifying a file as the
>list but that doesn't go.
>
>Anyone else had a crack at this?
>--
>M

-- 
              _/_
 __.  ____  o /      
(_/|_/ / /_<_<__
Received on Thu Apr 13 1995 - 00:00:00 CEST

Original text of this message