Question Locked

Oracle 10g Data Pump Export

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We are looking at importing about a Terabye of data into our Oracle 10 database, and I am trying to come up with the best possible way to pull this off. I've been doing some reading online and the data pump export / import looks pretty attractive. I would like to get some insight about your past experiences with data pump export. Has anybody tried it with large volumes of data? How did it go? Were there any problems?

2 replies

by waseem.parkar

Hi Dawson,

Data Pump is really handy utility.
I have used it ample time for fast data load.
For sizeable tables.

I suggest that for large tables you use data pump and for small tables use normal export import. Small being < 10,000 rows.
The reason I think is the overhead while using datapump as it converts to XML dump.

In 1 hour I exported 150GB of data using datapump.

Please do try it.

Thanks.

This discussion is closed to new replies.