Re: ORACLE exports
Date: 8 Oct 92 00:54:46 +1000
Message-ID: <1992Oct8.005446.403_at_hhcs.gov.au>
In article <1992Oct7.000919.947_at_cerberus.bhpese.oz.au>, brad_at_cerberus.bhpese.oz.au (Brad Keifer) writes:
> Is there a limit on the number of tables that can be specified to export
> when performing an export from ORACLE areas?
> I have discovered a problem with some exports that I was automatically
> performing.
> The ORACLE version is 6.0.31.0.1, running on an RS/6000 AIX Version 3.2.
> I have an sql script that generates a "PARFILE" that contains a file name to
> store the export in, followed by a series of table names. I have found
> that only the first 98 tables actually get exported. The export routine
> does not indicate an error, in fact it says that the export terminated
> successfully.
> --
Don't know about the number of tables but I know that one of our DBA's in
Queensland ran into similar problems when his parfile had approximately 200
users. Split into 2 parfiles, it worked fine (using Oracle 6.0.34 on VMS 5.5).
Perhaps there is a generic problem using big parfiles like this? By the way,
wouldn't it be easier to export by owner, if all these tables are owned by one
user?
Regards
Peter Received on Wed Oct 07 1992 - 15:54:46 CET