Hi
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?
Cheers
Nandu
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
Regards
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Click Here to Expand Forum to Full Width
|