Home » RDBMS Server » Server Utilities » Troubleshoot for import data
Troubleshoot for import data [message #429680] Thu, 05 November 2009 03:33 Go to next message
Messages: 1
Registered: November 2009
Location: Viet Nam
Junior Member
Hi ,all
Please reply me How to tuning oracle PUMP data

+ My database size is 1,2 TB
+ 20 users which have default user,temp tablespace
+ undo_retention : 43200
+ online redo log : 104 MB which in 3 log group

When I delete one user to import new data for this user
My size .dmp file : 15 GB
My database is very slowly to do this (about 4 days or more )
How can i increase speed to import data.

My information server :
CPU: xeon 2.2GHZ
Hard disk: 2 TB(intel MegaSR SCSI Disk)

Re: Troubleshoot for import data [message #429830 is a reply to message #429680] Thu, 05 November 2009 22:40 Go to previous message
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
chuotlun4mat wrote on Thu, 05 November 2009 03:33
Hi ,all
Please reply me How to tuning oracle PUMP data

From which version ?

Previous Topic: Data Pump API error help
Next Topic: dataloading with sql*loader without archie
Goto Forum:

Current Time: Fri Oct 21 17:37:14 CDT 2016

Total time taken to generate the page: 0.36406 seconds