| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Interesting Information ... BUT is it correct, or not?
In article <37beaf7a.3004350_at_newshost.us.oracle.com> tkyte_at_us.oracle.com writes:
>>I am trying to pull data from an ancient 7.0 database to a 7.3.3 database
>>both of them set to RBO and optimiser_undo_changes=true (Oracle Financials
>>requires this) via a dblink (pl/sql cursor loop/fetch insert cycle). I
>>was getting end of channel ORA errors until I put a FIRST_ROWS hint in my
>>cursor. There are no statistics on either database.
>>The question is what is FIRST ROWS doing that allows my PL/SQL procedure
>>to complete without erroring out?
>what errors? if they are 3113 type of errors or 600, there will be trace files
>in the user_dump_dest on the server (check your alert log as well)
Can't remember, since the problem went away I didn't make a note of it. Once this project is over I'll take the hint out to see what it was.
>You'll find the sqplus copy command to be inifitely faster then a plsql loop to
>bulk copy data between servers. see the sqlplus guide for information.
I am using the copy command for some of my data migration. However this is an Oracle Financials conversion from 9.4 ->10.7 so you can't just pull over the data directly as table structures have changed; you have to populate the open interface tables and at the same time do some complex mapping of the data. For example there are over a hundred (it feels like) new attributes in MTL_SYSTEM_ITEMS that have no equivalent in the old system.
Also my cursors are basically select blah from oldtable_at_oldfin where not exists (select 'X' from newtable where oldtable.item = newtable.item). How do I do this with sqlplus copy?
By the way, thanks for the prompt reply. It's not critical since I have a workaround. I just wonder *why* it works this way though. (Primate->Itch->Scratch you know)
Philip
---=====================================================================---Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA e-mail: philip_at_aleytys.pc.my Voice:+60-5-545-1011 Fax:+60-5-547-3932 Guard us from the she-wolf and the wolf, and guard us from the thief,
oh Night, and so be good for us to pass.
---
 |
 |