Re: QS for oracle DBA working on SAP R3 system

I agree with John. The only exceptions I would make are for Besoke Tables built by yourselves. You could get into all kinds of problem bypassing the supported SAP Batch Input.

There are however a few SAP-R3 options you could explore. Try search the SAP documentation under Batch Input or Data Load. I can;t remember the references offhand but there are about 3 basic options available.

The other thing you could do at the Oracle level is tune for large data loads. (spread the IO, ensure the SGA and PGAs are performing well. At the SAP level you could check the number of processes available for update and concurrency of this operation.

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <Kevin.Lewis_at_BOCMPAULS.co.uk>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. John Higgins <JH33378_at_deere.com> wrote in message news:3727BFBD.8DF00EF4_at_deere.com...
> 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 Thu Apr 29 1999 - 03:32:37 CDT