OraFAQ Forum: SQL & PL/SQL » Rows deleted automatically

Home » SQL & PL/SQL » SQL & PL/SQL » Rows deleted automatically (oracle 9.2.0 , solaris 8)

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

Rows deleted automatically [message #295995]

Thu, 24 January 2008 02:35

sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore

Junior Member

Hi all,

I have inserted 11000 rows into a table using sql*loder.
After insertion when I check
Select count(*) from code_sets;
COUNT(*)
----------
11000

But after 3hours when i am checking it shows
COUNT(*)
----------
0

Can u please give me suggation what might be the problem.

Regards
Sushil

Report message to a moderator

Re: Rows deleted automatically [message #296000 is a reply to message #295995]

Thu, 24 January 2008 03:06

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

1. Somebody issue "truncate" command on table
2. There is any trigger will truncate table

Report message to a moderator

Re: Rows deleted automatically [message #296006 is a reply to message #295995]

Thu, 24 January 2008 03:16

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

3 Or else you queried on same table but in another Schema Smile

Rajuvan.

Report message to a moderator

Re: Rows deleted automatically [message #296008 is a reply to message #295995]

Thu, 24 January 2008 03:18

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Or you didn't commit, or you session has been killed, or you have a profile with idle time, or...

In short, either you didn't commit either someone else delete the rows.

Regards
Michel

Report message to a moderator

Re: Rows deleted automatically [message #296010 is a reply to message #295995]

Thu, 24 January 2008 03:30

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

But do we need rellay to commit once data is loaded using SQL*Loader ?

OP has alredy seen that Data after loading .
on his posting

Quote:

I have inserted 11000 rows into a table using sql*loder.
After insertion when I check
Select count(*) from code_sets;
COUNT(*)
----------
11000

Rajuvan.

Report message to a moderator

Re: Rows deleted automatically [message #296012 is a reply to message #296010]

Thu, 24 January 2008 03:33

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I didn't see "sql*loder" sorry.

Regards
Michel

Report message to a moderator

Previous Topic:	FORMAT DATA IN EXCELSHEET
Next Topic:	Select Cross Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 07:17:27 CST 2024