Question Locked
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 dawson_davis Accepted solution
Clarifications
by waseem.parkar Accepted solution
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.
Trending IT Employment posts
Sort by Trending
0 helpful
3 replies
0 helpful
11 replies
0 helpful
1 reply
0 helpful
6 replies
Discussion Locked
How should organizations verify AI generated information before using it
0 helpful
0 replies