Re: Data Pump for Peoplesoft database
- Even with a well tuned database datapump will be slow because the DDL
portion cannot be done in parallel. Only data loading can be done in
parallel. Since PeopleSoft apps have many tables, many of zero
length, it cannot take advantage of the parallel capabilities of
Datapump, which is the main reason datapump is faster than the older
import/export. In my experience unless you have some extremely large
tables where imp/exp takes a significant portion of time in the data
load/unload you will see minimal gains moving to datapump. Unless we
need to use datapump for moving between platforms, we generally
duplicate the database from a backup via RMAN, which runs in less than
10% of the time for a datapump. Datapump is good for moving big
tables around though.
--- In email@example.com, "vjkidambi" <vjkidambi@...> wrote:
> I would like to know whether someone is using Data Pump Export and
> Import for Peoplesoft database. As there are about 75 thousand tables,
> the data pump import is not fast. Our database is 40 GB and the import
> takes a long time (about 8 hours). I have tried parallel option too. It
> is not faster than the conventional exp and imp.
> I have a another database for a home grown application. Although the
> database is 140GB in size the data pump export and import is much
> faster than the traditional exp and imp.
> Let me know if someone has any suggestions. The database version is
> 10.2.0.3 and the OS is Windows 2003.