public void BulkCopyWriteToServer(DataTable data, string tableName)
 {
     using (var connection = _database.CreateConnectionForBulkCopy())
     {
         try
         {
             connection.Open();
             using (var bulkCopy = new OracleBulkCopy(connection))
             {
                 bulkCopy.DestinationTableName = tableName;
                 bulkCopy.WriteToServer(data);
             }
         }
         catch (Exception ex)
         {
             throw ex;
         }
         finally
         {
             connection.Close();
         }
     }
 }