Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What does the option Prefer Fast Copy [in the synchronization script] do?

April 26, 2017copy fast option prefer synchronization

0

Posted

What does the option Prefer Fast Copy [in the synchronization script] do?

1 Answer

0

Posted

TOYS preserves table data by either (i) unloading table data to external files and re-loading -or- (ii) copying table data internally using SQL or PL/SQL. The option Prefer Fast Copy only applies to internal copying. With this option enabled, TOYS will use an INSERT INTO table SELECT … in preference to a PL/SQL block where ever possible. The insert is much faster but may fail on large tables due to insufficient undo segment space.