Oracle Database Discussions

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... Hangs

596722Feb 25 2009 — edited Mar 3 2009

Hi,
Create table xxx as select col1, col2 from myTable hangs. myTable is a very small table with few hundred rows, but still create table fails.

Can anyone suggest where to and what to check and what action needs to be taken. Its a Production database, so cannot afford to restart the db.

Thanks
SA

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2009

Added on Feb 25 2009

#general-database-discussions

28 comments

5,087 views