Re: EXporting lots of tables

Amit Srivastava (amit_at_miller.cs.uwm.edu) wrote:
: 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.

Bon Jour Netizens del Mundo,

According to other postings on the Oracle-L list server, you can encounter platform specific errors because of limitations on the SIZE OF THE PARAMETER file!!! The suggested work around was to break the components of the Pfile into pieces and invoke EXP a corresponding number of times (yuk for automated  EXP processes kicked off by scripts generated from Oracle DD queries).

If you are not generating a Pfile larger than 4K-8K, you may not have problems.

Anyone needing the specific message threads about this incredibly exciting topic can send private email to:

        PierceED_at_csus.edu

Have a good datum,

EP

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

I've been tempted to loosen my belt a few times. ;^)

: >--
: >M
:
: --
: _/_
: __. ____ o /
: (_/|_/ / /_<_<__
Received on Fri Apr 14 1995 - 00:00:00 CEST