Stack Overflow
Stack Overflow

Questions tagged [bulk-operations]

60 questions
0
votes
1 answer

how to run the stored procedure in batch mode or in run it in parallel processing

We are iterating 100k+ records from global temporary table.below stored procedure will iterate all records from glogal temp table one by one and has to process below three steps. to see whether product is exists or not to see whether product…
user739115
  • 1,117
  • 5
  • 20
  • 41
0
votes
1 answer

delete large data from a large table oracle

I have a table with 400 million records, with one clob column. Size of table is around 30 gb. I want to delete 250 million records from it. I have tried traditional delete in small chunks. create table as select ... insert into select... All…
Vineesh Choudhary
  • 23
  • 8
0
votes
2 answers

Procedure: commit after 10000 records

CREATE OR REPLACE PROCEDURE testing AS BEGIN insert into t3 select * from t2; insert into t1 select * from t4; commit; EXCEPTION WHEN OTHER THEN ROLLBACK; END; This will work fine t2 - 3 millions t4 - 3 millions total i have 6…
Aman
  • 226
  • 1
  • 4
  • 17
0
votes
1 answer

PLSQL script optimisation / tuning

I have this plsql script. I was able to test this on a test table with around 300 rows and it is working perfectly fine. However when I tried to run this using the actual table which is around 1M rows, it doesn't complete. I would like seek for your…
Shin
  • 3
  • 2
0
votes
1 answer

MERGE INTO multiple statements at once Oracle SQL

I have a merge into statement as this : private static final String UPSERT_STATEMENT = "MERGE INTO " + TABLE_NAME + " tbl1 " + "USING (SELECT ? as KEY,? as DATA,? as LAST_MODIFIED_DATE FROM dual) tbl2 " + "ON (tbl1.KEY= tbl2.KEY) " + …
userit1985
  • 961
  • 1
  • 13
  • 28
0
votes
4 answers

Bulk inserting in Oracle PL/SQL

I have around 5 million of records which needs to be copied from table of one schema to table of another schema(in the same database). I have prepared a script but it gives me the below error. ORA-06502: PL/SQL: numeric or value error: Bulk bind:…
Nik
  • 204
  • 1
  • 7
  • 18
0
votes
1 answer

oracle pl/sql update query

I have an update query which is taking 10 hours to update and still it is in the updating stage itself it has about 135171 records only. uPDATE hr.raw_address ora SET (ora.addr_id, ) = (SELECT oms.addr_id …
Rak kundra
  • 168
  • 11
0
votes
0 answers

Insert 1 million entries to oracle

I have an use case, where we get requests, each request has around 1 million line items. As data is very important, we persist those 1 million entries(per request) to oracle db in chunks of size 100. Can you please suggest me with the best practices…
paul
  • 3
  • 2
0
votes
1 answer

Update only 1000 records at a time in oracle

I am pretty new to oracle. My current scenario is I need to add a NOT NULL column and update its value to 'EE'. This is done using below script. ALTER TABLE CSA.CSA_CALL_AUDIT ADD CSA_CALL_TYPE varchar2(10); update CSA.CSA_CALL_AUDIT set…
AnishK
  • 11
  • 4
0
votes
4 answers

How to run an insert script file in oracle with around 2.5 million insert statements?

I have an insert script file in oracle with around 2.5 million insert statements. Idea needed to insert into Oracle table. I have tried inserting using SQL Developer, by executing the file directly @path\script.sql. But it times out.
ashwinsakthi
  • 1,856
  • 4
  • 27
  • 56
0
votes
1 answer

How to "Execute arbitrary PHP script" in Drupal 7?

I have been trying to make changes to some fields in my library project. I want to update the count of books on it's return. The return of book is implemented using bulk operation. How can I make changes in the other content types using arbitrary…
Rony Samuel
  • 462
  • 7
  • 20
0
votes
1 answer

hook_action_info does not create its VBO list item in view

I am trying to code my custom action using views and VBO. The my view shows the user a list of commerce line items. Here the code: function nlmcode_action_info() { return array( 'vbo_download_pdf' => array( 'type' => 'entity', …
loba76
  • 75
  • 1
  • 8
0
votes
1 answer

Group By on Consecutive Records for audit tables which has huge data in Oracle

I have an audit table in oracle whose data is growing very fast and has already became very large Looking that i have decided to cut short it by not auditing 'CALLED_TIME' column. So I need to delete records from audit table where audit got recorded…
Ravi Sahu
  • 890
  • 1
  • 11
  • 24
-1
votes
2 answers

Dropping All SP's taking time - SQL server 2019 (SSMS)

I have a request to drop all the store procedure in SQL Server 2019, to start with I have generated the dynamic script to drop all the procedures which are more than 11000 using SSMS however, when I executed the statement it was running very slow…
Vinu
  • 1
-1
votes
2 answers

getting entire data into collections using oracle PLSQL Bulk collect with limit clause

I have one table called EMP with 140000 rows and I need , to keep entire data into collection .How to extend collection and load entire data into collection using "BULK COLLECT ..LIMIT" clause feature. The below logic not providing required result ,…
MastanSky
  • 57
  • 1
  • 10
1 2 3
4