SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CREATE TABLE AS (SELECT...) never ends

631954Apr 3 2008 — edited Apr 11 2008

I tried to create a table as a select result and the query never ends. The inside SELECT only takes 8 min. to ending successfully, thougt.

I know we had to change a parameter in the 'init.ora' 3 months ago due a bug detected in DB with a similar query that got wrong results.

Could this be the same?

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on May 9 2008

Added on Apr 3 2008

12 comments

1,984 views