drop unused columns issue
Hi there,
I'm trying to drop unused columns from table TABLE1, but this cant be done. Exact steps:
1) SELECT * FROM DBA_UNUSED_COL_TABS -- gives COUNT=72 for the table OWNER1.TABLE1;
2) ALTER TABLE OWNER1.TABLE1 DROP UNUSED COLUMNS -- no error, successfully done;
3) when trying step 1 - gives the same COUNT=72 for the OWNER1.TABLE1 table, i.e. unused columns still not dropped.
Actually this unused columns issue prevent me from being able to run the partition exchange command, which ends up with the ORA-14097 error.
My database is 11.2.0.2.0 on HP UX.
Appreciate if anyone could help on with this issue,
I'm trying to drop unused columns from table TABLE1, but this cant be done. Exact steps:
1) SELECT * FROM DBA_UNUSED_COL_TABS -- gives COUNT=72 for the table OWNER1.TABLE1;
2) ALTER TABLE OWNER1.TABLE1 DROP UNUSED COLUMNS -- no error, successfully done;
3) when trying step 1 - gives the same COUNT=72 for the OWNER1.TABLE1 table, i.e. unused columns still not dropped.
Actually this unused columns issue prevent me from being able to run the partition exchange command, which ends up with the ORA-14097 error.
My database is 11.2.0.2.0 on HP UX.
Appreciate if anyone could help on with this issue,
0