Re: IMP/EXP parfile question

From: Ronald Rood <devnull_at_ronr.nl>
Date: Sat, 1 Oct 2005 20:34:22 +0200
Message-ID: <0001HW.BF64A34D01B1E7A2F0284550@news.individual.net>

On Sat, 1 Oct 2005 19:58:50 +0200, Mark D Powell wrote (in article <1128189530.864734.131130_at_g43g2000cwa.googlegroups.com>):

> What version of Oracle? Traditional exp utility or expdp?
>
> Back in the days of version 7 and I think still in 8.0 the tables=
> parameter had a limit of 99 tables, but I have exported more than 150
> on 9.2.
>
> Here is a way to test: generate a parfile with all 40,000 tables listed
> one per line and run an export with rows=n which will just export the
> DDL. If the exp runs through all 40K tables you do not have to worry.
> If it stops at a certain point then you will likely be able to identify
> how many lines a tables= parameter can handle.
>
> HTH -- Mark D Powell --
>

It's something that I think that is not tested at all by oracle. Even in 10g large parameters still give segmentation faults.

With kind regards / met vriendelijke groeten, Ronald

http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle Received on Sat Oct 01 2005 - 13:34:22 CDT