| Table hang [message #132902] |
Tue, 16 August 2005 14:21  |
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
|
Senior Member |
|
|
I have a table XYZ with 750000 Rows .. This table is behaving strange .. I can do a count(*) from the table ..
but i cant analyze the table ..not even with sample 10% ...also export of the schema hangs on that table ..
I tried create abc table as select * from xyz which failed too ..
what could be the reason ?
Thanks for the help
-sai jeedigunta
|
|
|
|
| Re: Table hang [message #132903 is a reply to message #132902] |
Tue, 16 August 2005 14:48  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
versions of oracle/os?
did you check for DML locks on the object?
>>I tried create abc table as select * from xyz which failed too ..
what was the error?
And, before collecting new statistics, always remove the old statistics.
Did you validate the structure?
sql> analyze table table_name validate structure cascade;
and
Enable Trace 10046 , level 8 and post the relevent contents of tkprof output
[Updated on: Tue, 16 August 2005 14:52] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
