Home » SQL & PL/SQL » SQL & PL/SQL » Row getting deleted from table after insertion
Row getting deleted from table after insertion [message #264528] Mon, 03 September 2007 11:54 Go to next message
techie_chait
Messages: 5
Registered: September 2007
Junior Member
Hi All,

I am a new member.

I have one peculiar problem related to oracle.

I have a table where I am inserting rows. After inserting when I query the table I am able to see the inserted row but when I query the table again after some time I am not able to see the inserted row. It gets deleted.

I checked for any triggers/procedures/functions which is deleting the rows from the table. But there are none. Can you please advise?

There is one view related to this table and there are no triggers/procdures/functions on this view as well.

Regards
Murthy.
Re: Row getting deleted from table after insertion [message #264529 is a reply to message #264528] Mon, 03 September 2007 11:55 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did you commit?
Re: Row getting deleted from table after insertion [message #264530 is a reply to message #264528] Mon, 03 September 2007 11:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you commit?

Regards
Michel
Re: Row getting deleted from table after insertion [message #264535 is a reply to message #264528] Mon, 03 September 2007 12:02 Go to previous messageGo to next message
techie_chait
Messages: 5
Registered: September 2007
Junior Member
Hi,

Yes. Actually this rows in a table are populated through a DBLink.

Regards
Murthy
Re: Row getting deleted from table after insertion [message #264536 is a reply to message #264535] Mon, 03 September 2007 12:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post exactly what you made.

Regards
Michel
Re: Row getting deleted from table after insertion [message #264537 is a reply to message #264535] Mon, 03 September 2007 12:07 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
so?
Did you commit in the session after the insert.
The fact that the insert took place over a dblink has nothing to do with the commit.

Did you use the same session for your first and consecutive select?
Re: Row getting deleted from table after insertion [message #264541 is a reply to message #264535] Mon, 03 September 2007 12:22 Go to previous messageGo to next message
techie_chait
Messages: 5
Registered: September 2007
Junior Member
Hi,

See the actual scenario is that the table is getting populated through a DBLink and I need to use the rows on this table.The table is also present in another instances but the rows are not getting deleted from other instances.

Regards
Murthy
Re: Row getting deleted from table after insertion [message #264542 is a reply to message #264541] Mon, 03 September 2007 12:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
./fa/1597/0/
Copy and paste what you've done.
Nothing more, nothing less.

Regards
Michel

[Updated on: Mon, 03 September 2007 12:26]

Report message to a moderator

Re: Row getting deleted from table after insertion [message #264543 is a reply to message #264541] Mon, 03 September 2007 12:26 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Its might be that the table might have been created like

create global temporary table
Re: Row getting deleted from table after insertion [message #264548 is a reply to message #264543] Mon, 03 September 2007 13:24 Go to previous messageGo to next message
techie_chait
Messages: 5
Registered: September 2007
Junior Member
Hi

No it is not a global temporary table

Regards
Murthy
Re: Row getting deleted from table after insertion [message #264571 is a reply to message #264548] Mon, 03 September 2007 14:54 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is it? A quiz? Are you going to post the code or not?

By the way, are you *sure* you are working with the same table all the time?
Re: Row getting deleted from table after insertion [message #264755 is a reply to message #264571] Tue, 04 September 2007 08:10 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Littlefoot wrote on Mon, 03 September 2007 15:54
What is it? A quiz?


My answer is D, Someone else has executed a DELETE command.
Re: Row getting deleted from table after insertion [message #264803 is a reply to message #264755] Tue, 04 September 2007 11:00 Go to previous message
techie_chait
Messages: 5
Registered: September 2007
Junior Member
My apologies. I dont have enough information
Previous Topic: to compare dates in oracle
Next Topic: Unique index?
Goto Forum:
  


Current Time: Sun Dec 11 00:18:47 CST 2016

Total time taken to generate the page: 0.10356 seconds