Hi, I have a table with 700000 rows on 220.127.116.11.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.