Re: QS for oracle DBA working on SAP R3 system

Of course you can.

However !!!

SQL*Loader does none of the checking that is built into the ABAP transactions. And, since SAP puts all of its integrity checking into the ABAP programs (no RDBMS foreign keys), you might load "orphans". Not to mention SAP's pool and cluster tables (no, these are NOT Oracle clusters). You (nor me) would know how to build the control statement to get SQL*Loader to work on these.

In other words, I would not do it.

By the way, the redo logs probably need to be increased to 200MB

christinezhao_at_hotmail.com wrote:

> Hi All,
>
> We are loading huge data to our oracle database with SAP R3 on top of it. We
> are using ABAP programming to load those data. it creates 20 M redo log very
> 3- 5 mins. We are running brbackup to clean it to tape. I am just wondering
> can I use SQL*loader direct path to load data to SAP database? Can I do
> anything in oracle side to speed up loading and also being accepted by SAP?
>
> Thanks a lot!
> --
> Christine Zhao
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Apr 28 1999 - 21:11:09 CDT