PROBLEM:
While trying to drop a column from a table, owned by SYS, got below error.(ORA-12988)
SOLUTION:
oerr ora 12988
12988, 00000, “cannot drop column from table owned by SYS”
// *Cause: An attempt was made to drop a column from a system table.
// *Action: This action is not allowed
We can’t drop a column from a table owned by SYS user. There is an alternative method to achieve this.
step 1. Create the table under different schema(using CTAS) let’s say DBACLASS user.
step 2. Now drop the column from the newly created table
step 3. Now drop the original table owned by SYS
step 4. Again create the table using CTAS from the dbaclass.test4 table.
In this case, if any indexes were present, then those need to be recreated again.
Catch Me On:- Hariprasath Rajaram Telegram:https://t.me/joinchat/I_f4DkeGfZuxgMIoJSpQZg LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/ Facebook:https://www.facebook.com/HariPrasathdba FB Group:https://www.facebook.com/groups/894402327369506/ FB Page: https://www.facebook.com/dbahariprasath/? Twitter: https://twitter.com/hariprasathdba
