When I execute a SELECT query it returns 580 records.
When I use the same query in the INSERT statement "INSERT INTO
SELECT..." it populates 616 records.
The table into which it is inserted in empty.
Materialized views are part of the SELECT query. So we removed he materialized views and created tables instead. The problem seemed to be resolved temporarily. But it popped up again now with the tables itself.
I am unable to comprehend the actual problem. Have any of you faced similar problems or any pointers to the issue?
Last edited by nandu; 11-16-2006 at 01:44 AM.
Never give up !
Nanda Kumar - Vellore
Please do explain plan for both and post the result here. It can give an idea about what happens. The queries would be useful as well
Click Here to Expand Forum to Full Width