Re: EXporting lots of tables

From: Keith Bremer <kbremer_at_lecky.demon.co.uk>
Date: 1995/04/15
Message-ID: <412835473wnr_at_lecky.demon.co.uk>#1/1


In article: <797804393snz_at_minarama.demon.co.uk> mark_at_minarama.demon.co.uk (Mark Haston) 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
>
>

--
Mark,
  You should try the EXP parameter file, invoked as...
$ exp userid=xxx/yyy parfile=file
  then in the file specified put...
TABLES=(EMP, DEPT, SALGRADE, etc...)

	Hope this helps... 
---------------------------------------------------------------------------
| Keith Bremer    EMail kbremer_at_uk.oracle.com                             |
---------------------------------------------------------------------------
Received on Sat Apr 15 1995 - 00:00:00 CEST

Original text of this message