Use Oracle’s fast loader - Connect_CDC - connect_cdc_mimix_share - 5 - 5.8

Connect CDC Advanced User Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC Advanced User Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-27
ft:lastPublication
2023-09-27T18:12:55.651884

When you use Oracle’s fast loader, you must specify Oracle’s bin directory in your path.

Oracle’s fast loader uses TNS for connection. Therefore, you must have an entry in the tnsnames.ora file that is the same name as the server name on the Server Properties window, as shown in the following excerpt:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <machine name>)(PORT
= 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

In this example the server name on the Server Properties window is orcl.

Connect CDC uses the “direct path” option of Oracle load to get the best performance from the load. During direct path loading, Oracle SQL*Loader turns referential integrity constraints off.

  • If the copy request ends normally, the referential integrity constraint check is explicitly turned on again when the request ends.

  • If a user were to stop the request in the middle or shut the kernel down, the error mode cannot automatically turn the referential integrity constraint on since SQL*loader might still be running at this time.