asked on
alter table is not working on a particular table
Hi, I have a table with 700000 rows on 9.2.0.8.0 database. i am trying to analyze this table
analyze table tablename estimate statistics sample 20 percent; This is running forever, and I am not able to alter this table alter table rename, alter table move etc.
I created one temp table by selecting data from this table which is being analyzed in couple of seconds,
Please help me on it.
analyze table tablename estimate statistics sample 20 percent; This is running forever, and I am not able to alter this table alter table rename, alter table move etc.
I created one temp table by selecting data from this table which is being analyzed in couple of seconds,
Please help me on it.
Oracle Database
Last Comment
dba1234
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
what are the wait events for the session that is taking a long time?
how big is the table? rows, blocks, bytes? 0 rows could still be terabytes of allocated space
how big is the table? rows, blocks, bytes? 0 rows could still be terabytes of allocated space
ASKER
It is 20 MB table with 700000 rows.
There is just one lock library cache lock
There is just one lock library cache lock
ASKER
Thanks I was able to alter the table after killing the session who was holding library cache lock
I got one object locked but that is different object uder different schema.