| Loading batch [message #378403] |
Tue, 30 December 2008 05:22  |
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 #378417 is a reply to message #378407] |
Tue, 30 December 2008 05:59  |
 |
Littlefoot
Messages: 21808
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
