OraFAQ Forum: Reports & Discoverer » How to know whether the table is in the process of updating records

Home » Developer & Programmer » Reports & Discoverer » How to know whether the table is in the process of updating records

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to know whether the table is in the process of updating records [message #419709]

Tue, 25 August 2009 05:09

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

Report message to a moderator

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

cookiemonster
Messages: 13958
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.

Report message to a moderator

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

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

Report message to a moderator

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

cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester

Senior Member

Are you using sqlplus or sqlloader?
Are you inserting records or updating records?

Report message to a moderator

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

MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI

Member

iam using sql Loader and iam using insert statement

Report message to a moderator

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

cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester

Senior Member

I'm pretty sure you can configure sqlloader to just commit once.

Report message to a moderator

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Can you use cursors and if so, how?
Next Topic:	Analytic Workspace Manager

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 04:48:47 CST 2024