Stack Overflow
Stack Overflow

Questions tagged [bulk-operations]

60 questions
0
votes
0 answers

DB2 migration to Oracle using Shell Script

I am migrating data from DB2 to Oracle in a daily basis.I have created identical table in oracle (destination) as in DB2 (source). I can able to migrate the data from DB2 to Oracle with out any issues but it takes almost 40 minutes to migrate…
Fish
  • 57
  • 5
0
votes
2 answers

Read and update an Oracle table with 20 millions records

I have a situation where I am doing a data fix from back up. Table MAIN TABLE (PrimaryKey, Value) and Table BACKUP(PRIMARYKEY, Value). I want to find all the records in MAIN Table with value=0 , then go fetch the value for the same primary key from…
Marco
  • 83
  • 1
  • 10
0
votes
2 answers

the faster way to extract all records from oracle

I have oracle table contain 900 million records , this table partioned to 24 partion , and have indexes : i try to using hint and i put fetch_buffer to 100000: select /+ 8 parallel +/ * from table it take 30 minutes to get 100 million records my…
code
  • 99
  • 1
  • 7
0
votes
0 answers

bulk delete in performance way with incremental fashion

We want to delete some matching rows within the same table seems to have a performance issue as the table has 1 billion rows. Since it Oracle database, we can use PLSQL as well to incrementally delete, but we want to see what options available just…
user1595858
  • 3,700
  • 15
  • 66
  • 109
0
votes
1 answer

Merge is taking time to update

I am trying to update one column CODE from table TAB1 using REF_TAB table having 200 mn and 30 mn records respectively, but it is taking 3-4 hrs to update the records. TAB1 -- 200000000(200mn) ID VARCHAR2(10) PK on ID T_ID VARCHAR2(10) ---…
kashi
  • 61
  • 1
  • 12
0
votes
1 answer

Bulk insert, update values mongodb

I run a bulk insert cron job everyday. But some values get missed and when I rerun the data, the values are added to the existing data rather than updating. Is there a way to do an insert only documents that have not yet been inserted. My code: …
nb_nb_nb
  • 1,243
  • 11
  • 36
0
votes
2 answers

oracle Cursor + FORALL taking time

I wrote the script below in Oracle that inserts thousands of rows in a table and uses the auto-generated id resulted from these rows and uses it in other inserts. The script is working as expected but the issue is that it takes time to…
ghostman
  • 13
  • 1
  • 6
0
votes
0 answers

multiple IF inside cursor loop

after this question, I'm unable to evaluate with different IFs statements inside one single loop, my execution ends with ORA-01403: no data found What I have: Declaration: CREATE OR REPLACE PACKAGE MYSCHEMA.MYPKG AS FUNCTION MYFUNCTION (…
downtheroad
  • 409
  • 4
  • 11
0
votes
2 answers

Atomic multiple insert with parameter binding in Oracle

I'm writing a php code to upload a csv file into an Oracle DB by mean of php oci. I want an atomic insertion of all the rows of the file i.e if one row has missing/wrong field then whole csv file must not be inserted in DB. I know I can achieve this…
mp94
  • 47
  • 6
0
votes
1 answer

MongoDB Bulkwrite which queries failed at match step?

I am doing bulkwrite operation in MongoDB to update multiple documents at a time. Now Is there any way by which I can know which sequence number of my queries match step failed. Because in returned document I am getting nModified, nMatched which…
Sudhanshu Gaur
  • 7,486
  • 9
  • 47
  • 94
0
votes
1 answer

How can I enhance a Drupal 8 Views Bulk Operations Confirm Page?

For a custom Views Views Bulk Operations action, I would like to enhance the information in the list on the confirm page, For example, instead of: LastName1 LastName2 I would like to have: LastName1, FirstName, Prefix LastName2, FirstName,…
jmux
  • 184
  • 4
  • 17
0
votes
1 answer

Insert huge data into Oracle DB

My setup - Oracle DB 12.1C, Spring application with Hibernate. table: create table war ( id int generated by default as identity not null constraint wars_pkey primary key, t1_id int references t1 (id) on delete cascade …
Lukas Forst
  • 802
  • 1
  • 8
  • 25
0
votes
1 answer

Oracle tuning insert from a remote table using dblink

I have a remote table with 300 millions of records, I need to insert all the data in a table in my local database. I try using BULK COLLECT clause. MERGE clause. PARALLEL INSERT All the options take too much time. What other options can I use…
Joseleg
  • 393
  • 9
  • 35
0
votes
1 answer

Oracle - Null or Blank parameter value in function

I'm trying to get the result from a function that makes a query, processes the fields and returns a collection. If I take the query of the function and execute separately, it returns in about 10 minutes, depending on the parameters that I put. If I…
Pablo F. Wachsmann
  • 15
  • 7
0
votes
1 answer

Wide table vs deep table in Oracle 12c - performance implications

Oracle gurus, We are at a point to decide the best approach to design a table with 500 columns wide vs a table with 8 columns wide but 4 billion rows deep. The table is going to be updated once a week, every Sunday with addition of a new week's…
Brendon
  • 57
  • 1
  • 7
1 2
3
4