Skip to Main Content
Forums

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 taking long time (more than 60 minutes) and still running

user1117837Jun 17 2010 — edited Jun 18 2010
Hi all,

I was able to create and drop table until yesterday, but now the when I issue the below statement the server is stuck, its showing creating table in process.... and then it hangs till you cancel the operation. Query of table and running the procedures are ok, so I am confused why only create table is having issues.

CREATE TABLE table1
( field1 VARCHAR2(20) );

Any help at the earliest will be appreciated,

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2010
Added on Jun 17 2010
#general-database-discussions
15 comments
6,613 views