'Create table' statement is hanging [message #681091] |
Mon, 15 June 2020 05:19 |
aidi-h
Messages: 45 Registered: November 2005
|
Member |
|
|
The 'CREATE TABLE' statement is hanging when I am running "CREATE TABLE m2sescal_calls AS SELECT...".
Test 1
Session 1) open up a Linux session using my personal account, login to sqlplus to the DB and run the above 'CREATE TABLE....' statement, it hangs
Test 2
Session 1) open up a Linux session using my personal account, login to sqlplus to the DB
Session 2) open up a 2nd Linux session using the same account and login to sqlplus to the DB and run the same above 'CREATE TABLE....' statement, the statement completes and builds the table.
Test 3
Session 1) logged in as the oracle user and this built the table successfully.
Checking v$locks didnt find anything. Any clues what might cause this as it seems very strange.
|
|
|
|
|
|
Re: 'Create table' statement is hanging [message #681104 is a reply to message #681103] |
Tue, 16 June 2020 12:44 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
Remember the create table command is NOT hanging, the query to make the data rows is what is hanging. If you just need the structure without any data rows (for now) add the line "and 1=2" into the where clause and it will build the table instantly but not bother to populate it
|
|
|