Load dumped .d files to new install database for Oracle for

Posted by vinhng on 14-Aug-2017 12:26

Hi all,

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

Vinh

All Replies

Posted by Dmitri Levin on 18-Aug-2017 17:05

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.

Posted by vinhng on 26-Aug-2017 13:16

Dear Dmitri,

Could you please let me know in detail which all steps way you done with Use Oracle External tables?

Thank in advance

Vinh

This thread is closed