I am facing the issue about Load dumped .d files to new install database for Oracle for Progress is too bad performance.
I am using the Progress OpenEdge 10.2B SP7 with Oracle 11.0.2 R2 in Windows 2008 R2 , all 64 bit also
I have a dumped .d files from customer
I try to new installation server as the same customer's services
I try to load dumped files to my environment but it takes too long time. for eg: I try to load the tr_hist.d with 1GB , it takes 4 days but not complete.
Anyone please guide me how I can load data with good performance than and how can I use multi session load some table name as the same time?
Thank in advances
You can load data with good performance in Oracle if you will not use Progress DataServer for load into Oracle.
Use Oracle External tables instead. The speed of load will be amazingly fast. In my experience Oracle load using external tables is about 4 times faster then dump from OpenEdge. YMMV.
Could you please let me know in detail which all steps way you done with Use Oracle External tables?
Thank in advance