Home » Developer & Programmer » Reports & Discoverer » How to know whether the table is in the process of updating records
How to know whether the table is in the process of updating records [message #419709] Tue, 25 August 2009 05:09 Go to next message
MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI
Member
Hi Friends,
Iam updating a table temp_live_script through VB each 10 minutes.It's working fine.

I have another oracle form in which i will be querying the table temp_live_script.

Since the table table is getting updating every ten minutes the user using the oracle form to query that table will not know when the table is getting updated. Sometimes he will run when the table is updated partially. How to overcome this problem .
Is it possible to find out whether the table is in the process of updating records or not so that we can give an alert message to the user to run after one minute.

please help me out to solve this problem
Re: How to know whether the table is in the process of updating records [message #419726 is a reply to message #419709] Tue, 25 August 2009 06:05 Go to previous messageGo to next message
cookiemonster
Messages: 12409
Registered: September 2008
Location: Rainy Manchester
Senior Member
I'd just make the update one transaction then the user will never see it in a partially updated state.
Re: How to know whether the table is in the process of updating records [message #419888 is a reply to message #419726] Tue, 25 August 2009 23:57 Go to previous messageGo to next message
MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI
Member
Iam updating the table each 10 minutes in a VB Form using sqlplus Loader.There i will be updating row by row only. So there i can't update the table in one transaction. In general i will be updating 8000 records each 10 minutes. Pls help me out with a solution to the above stated problem
Re: How to know whether the table is in the process of updating records [message #419988 is a reply to message #419709] Wed, 26 August 2009 06:14 Go to previous messageGo to next message
cookiemonster
Messages: 12409
Registered: September 2008
Location: Rainy Manchester
Senior Member
Are you using sqlplus or sqlloader?
Are you inserting records or updating records?
Re: How to know whether the table is in the process of updating records [message #419990 is a reply to message #419988] Wed, 26 August 2009 06:54 Go to previous messageGo to next message
MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI
Member
iam using sql Loader and iam using insert statement
Re: How to know whether the table is in the process of updating records [message #420017 is a reply to message #419709] Wed, 26 August 2009 09:39 Go to previous messageGo to next message
cookiemonster
Messages: 12409
Registered: September 2008
Location: Rainy Manchester
Senior Member
I'm pretty sure you can configure sqlloader to just commit once.
Re: How to know whether the table is in the process of updating records [message #420381 is a reply to message #420017] Fri, 28 August 2009 15:41 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Not explicitly, but - it is possible to set the ROWS parameter to a value which is higher from the largest number of rows that are going to be loaded into a table. In this example, as number of records is approx. 8000, perhaps setting ROWS=10000 might do the job.
Previous Topic: Can you use cursors and if so, how?
Next Topic: Analytic Workspace Manager
Goto Forum:
  


Current Time: Tue Dec 06 15:58:28 CST 2016

Total time taken to generate the page: 0.18714 seconds