Stack Overflow
Stack Overflow

Questions tagged [bulk-operations]

60 questions
15
votes
4 answers

bulk insert from Java into Oracle

I need to insert many small rows rapidly into Oracle. (5 fields). With MySQL, I break the inserts into groups of 100, then use one insert statement for every group of 100 inserts. But with Oracle, user feedback is that the mass inserts (anywhere…
Will Glass
  • 4,800
  • 6
  • 34
  • 44
12
votes
8 answers

Handling errors and feedback when performing bulk operations in a multi-tiered architecture

Let's say you have a business logic method that can perform some operation across a number of objects. Maybe you want to call a lottery number picking web service, once for each person selected from a list. In Java, the code might look something…
Adam Batkin
  • 51,711
  • 9
  • 123
  • 115
4
votes
0 answers

ORA-03137: malformed TTC packet from client rejected

In C# I am doing bulkcopy in oracle database then another stored procedure is called with oracle managed data access. Bulk copy is successful and inserts records in table. Next, when stored procedure executed getting the following error…
Balasubramanian Ramamoorthi
  • 67
  • 1
  • 9
3
votes
3 answers

How to efficiently extract large dataset from Oracle to a file?

I have a oracle server from where i need to extract data using python into files. These files are used by downstream systems as inputs. Few technical details: Oracle and Python are running on different server. The database is client hosted while all…
Rhythem Aggarwal
  • 346
  • 2
  • 15
3
votes
2 answers

Moving huge number of data in chunks

I am working on a script where a huge number of data should be queried based on some conditions and moved to some archive tables respectively. I have over fifty millions of records to scan through and select the matching records in order to perform…
sher17
  • 607
  • 1
  • 12
  • 31
3
votes
1 answer

Mongodb C# bulk update/replace on subcollection

The following object structure is given: public class RootDocument { public Guid Id { get; set; } public string SomeProperty { get; set; } public List Documents { get; set; } } public class ChildDocument { public Guid…
dna
  • 1,498
  • 1
  • 14
  • 35
2
votes
1 answer

Batch: how do you bulk rename files (getting close)?

I've seen people do this in Perl, but I'm wondering if there's a way to do it via batch? It's built into Windows, so I think it would be more useful to know how to do this with a batch script. It doesn't require installing anything onto a…
Wolfpack'08
  • 3,982
  • 11
  • 46
  • 78
2
votes
3 answers

How to delete huge rows in oracle table using parallel sessions query quickly

I am using mentioned query to delete 250 million plus rows from my table and it is taking more time I have tried with t_delete limit with up to 20000. Still slow deletion happening. Please suggest a few optimisations in the same code to done my job…
Praveen Nandyala
  • 41
  • 1
  • 3
2
votes
2 answers

FORALL and sql%rowcount when FORALL is never entered

I am curious how you guys deal with the problem that sql%rowcount is not set after a FORALL that is not entered at all. Example of how I solve it below (using a variable v_rowcount and the count of the collection the FORALL is based on). But I have…
Peter
  • 932
  • 5
  • 19
2
votes
2 answers

How to do conditional processing in a bulk collect loop?

we have Oracle 11G and i'm trying to move data from one table to another using bulk collect. Problem is when I tried to evaluate if one field from origin is empty my package got invalidated. What I have: Declaration: CREATE OR REPLACE PACKAGE…
downtheroad
  • 409
  • 4
  • 11
2
votes
1 answer

What is the best way to execute 100k insert statements?

I have created a set of 100k insert queries to generate data in multiple oracle tables for my performance testing. What is the best way to execute this ? In the past, I've tried tools like Oracle SQL developer and Toad. However not sure if it can…
Rajat Solanki
  • 77
  • 2
  • 12
2
votes
3 answers

Oracle SQL : How add IF condition inside FORALL LOOP

I am trying to merge table into emp1, if the select_count is not equal to 0. But I couldn't add select and if statement inside FORALL Loop. Can anyone help me to achieve this? Thanks. FORALL i IN 1 .. v_emp.LAST select count(emp_id) into…
Yosuva Arulanthu
  • 1,444
  • 4
  • 18
  • 32
2
votes
1 answer

Error - ORA-06502: PL/SQL: numeric or value error

I am learning PL/SQL. I have written the procedure below using cursor and nested table to display employee names. create or replace procedure employees_data is cursor c1 is select * from employees; type empl_tbl is table of c1%rowtype; …
niranjan kumar
  • 23
  • 1
  • 1
  • 3
2
votes
0 answers

SDL_RenderCopy with an array of Rectangles

SDL_RenderCopy only accepts a single input rectangle and a single output rectangle. But if I have a lot of images that I want to be filled, my knowledge of opengl tells me that a bulk operation that draws all images at once can be much faster than…
Arne
  • 7,921
  • 9
  • 48
  • 66
2
votes
2 answers

Business logic on multiple value objects - where to put the loop?

...and how best to handle success/failure feedback to the view layer. Options are: doBusinessLogic(things) or for (Thing thing : things) { doBusinessLogic(thing) } Assuming that we want a view layer that receives success/error feedback in a…
ireddick
  • 8,008
  • 2
  • 23
  • 21
1
2 3 4