Hi,

I have a Select Statement completing in 20 minutes, but when I try to create a Table with the Select statement(more than 10M Records) it takes more than 2 hours to complete. I have ti use the Table in a PL/SQL program for Data manipulation. I understand the Table creation involves selection and insertion of data. Is there anyway I can reduce the amount of time it takes to create the able ?

What would be the ideal way to proceed,

1. Table creation on the select statement and use the Table in the PL/SQL manipulation.
2. Create a View, and use the View or a select statement as a cursor and use BULK Collect to manipulate the data.

Please advise.

Thanks,
K

exec DBMS_monitor.session_trace_enable ( null, null, true, true );
***your code here***
exec DBMS_monitor.session_trace_disable;