Home » SQL & PL/SQL » SQL & PL/SQL » Rows deleted automatically (oracle 9.2.0 , solaris 8)
Rows deleted automatically [message #295995] Thu, 24 January 2008 02:35 Go to next message
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
Re: Rows deleted automatically [message #296000 is a reply to message #295995] Thu, 24 January 2008 03:06 Go to previous messageGo to next message
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

Re: Rows deleted automatically [message #296006 is a reply to message #295995] Thu, 24 January 2008 03:16 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

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

Thumbs Up
Rajuvan.
Re: Rows deleted automatically [message #296008 is a reply to message #295995] Thu, 24 January 2008 03:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Rows deleted automatically [message #296010 is a reply to message #295995] Thu, 24 January 2008 03:30 Go to previous messageGo to next message
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


Thumbs Up
Rajuvan.
Re: Rows deleted automatically [message #296012 is a reply to message #296010] Thu, 24 January 2008 03:33 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I didn't see "sql*loder" sorry.

Regards
Michel
Previous Topic: FORMAT DATA IN EXCELSHEET
Next Topic: Select Cross Server
Goto Forum:
  


Current Time: Sat Dec 03 17:55:54 CST 2016

Total time taken to generate the page: 0.15864 seconds