sqlldr problem

[mh60s]

Hi, I use sqlldr(9.2.0.1.0) to load data into a table.

sqlldr xxx/yyy control= ../abc.ctl direct=true

Load completed - logical record count record 851.

However when I query the table, no row selected. I'm confused and please help. Thanks in advance.

-mary

 

[aryeh1010]

This is a very strange problem indeed.

I would check to make sure that the table you are loading data into and the table you are selecting from are the same ones.

Could they be in differenct schemas, with the same name?

Is it possible that the table being loaded into is a global temporary table? I don't have time to check the documentation to see if you can load records into a global temporary table with sqlloader, but since no one else has offered you any suggestions, I will jump into the water.

Good luck

 

[aryeh1010]

This is a very strange problem indeed.

I would check to make sure that the table you are loading data into and the table you are selecting from are the same ones.

Could they be in differenct schemas, with the same name?

Is it possible that the table being loaded into is a global temporary table? I don't have time to check the documentation to see if you can load records into a global temporary table with sqlloader, but since no one else has offered you any suggestions, I will jump into the water.

Good luck

 

[naga5566]

I am not sure,but is that commited after the load proces ?