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.
I got one object locked but that is different object uder different schema.