For importing data, we analysed several options. After going through all options, to meet our need and to have good performance, we found external table is the only best option.
During external table creation, we pass 'DISABLE_DIRECTORY_LINK_CHECK' as part of access parameters list. This parameter is used to disable checking of file paths as symbolic links. This parameter was respected till Oracle12C. Now it has become a showstopping issue for us after we upgraded to Oracle 18C. Because from Oracle 18C onwards, this parameter is no more respected due to security reasons. This is throwing us exceptions when used on RAC envirnonments.
***Moderator note (Timo) removed MOS content as it's not allowed to disclose this kind of information here!***
Please let me know in case there are any workarounds to overcome this showstopping issue. For our case, we need a way to overcome this issue on RAC environment. Thank you in advance!
Regards
--Nagababu