Home » RDBMS Server » Server Utilities » Loading batch
Loading batch [message #378403] Tue, 30 December 2008 05:22 Go to next message
amitchhabra1981
Messages: 12
Registered: December 2008
Location: NOIDA
Junior Member
Hi All,

In our project we have to transfer the data from one database to another but while we are trying to transfer the data one of the table have over 40 million records so batch is runing infinetly and i am not able to see records in any table. so if someone can help me with that.

that will be really appreciated.


Regards,
Amit
Re: Loading batch [message #378407 is a reply to message #378403] Tue, 30 December 2008 05:30 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How do you do that "transfer"? Datapump? Export/import? INSERT statements? Something different?
Re: Loading batch [message #378417 is a reply to message #378407] Tue, 30 December 2008 05:59 Go to previous message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Received via PM
Hi,

we are using simple Pl/SQl for transfering the data.

Regards,
Amit

It appears that "simple" is not the "best"; I'd suggest you to use export/import (or data pump) utilities instead. Oracle 10g Utilities book; pay attention to Part I - Data Pump, as well as Chapter 19 (original export and import).



Please, do not use private messages to communicate about problems posted in a forum; it is just not the way to discuss them.
Previous Topic: update values in control file
Next Topic: IMp-00010 during export
Goto Forum:
  


Current Time: Mon Dec 05 15:08:04 CST 2016

Total time taken to generate the page: 0.13258 seconds