First of all, I want to use Oracle.DataAccess.dllto use OracleBulkCopy.
I want to know all the DLLs that I need to read from a database and then perform a large copy in Oracle. Currently, we use only one DLL to perform all readings from the databases we use Oracle.ManagedDataAccess.Client. But I can not use it to execute bulkCopy.
I do not want to install ODP.NET for users, I want to include the DLL directly in the program. Therefore, I want to know the minimum necessary DLLs in order to be able to use it Oracle.DataAccess.dllin the 32-bit and 64-bit versions.
I know that there are some old posts about this, but it is quiet old, and the listed DLLs are out of date. I can not find some of them.
I installed ODP.net for ODAC12, and I returned all the listed DLLs to this post . I also tried with this post. The DLLs listed point to version 11.
I created a dummy project that opens a connection, reads a table, and populates it in another table. I copied the listed DLLs from the messages in the root of the project, and I included Oracle.DataAccess.dllin the project.
When I run my program in 64 bit, I get the following error:
Could not load file or assembly 'Oracle.DataAccess, Version = 4.121.2.0, Culture = Neutral, PublicKeyToken = 89b483f429c47342'
When I run it in 32 bit, I get this error:
Unable to load DLL 'OraOps12.dll': the specified module could not be found. (Exception from HRESULT: 0x8007007E) "
The dlls I included include:
- oci.dll
- OCIW32.DLL
- Oracle.DataAccess.dll
- orannzsbb12.dll
- oraocci12.dll
- oraociei12.dll
- OraOps12.dll