Insert into table1 as select * from view1;
This was taking a few seconds to be executed on Oracle 9i database, but now since we migrated to a 10g database, the above insert statement is taking minutes (8-10). How can I resolve this?
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.