successfully loaded data is missing after few minutes!!
Hi all, I am loading the data into a table using insert /*+ direct */ into c select * from a,b as i wanna load data from 2 tables into one table. the query executes and shows 20000 rows added BUT after few minutes when i execute query like select count(*) from c, it shows 0 rows!! how this can happen??!!