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
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