ORA-30746: error occured while trying to drop column “string” in table “string”
Cause: The user tried to drop a subtype with VALIDATE option which tried to check for stored instances of the type in the stated table
Action: Delete all instances of this subtype and then drop the type.
ORA-30746 错误是一种Oracle 错误,当尝试在表中删除列时出现。它表明Oracle告知受请求事件的表中当前没有指定的列。
ORA-30746:“某表中没有指定的列”
ORA-30746错误出现在尝试在表中删除列时,查询表时调用改列,或者在运行相关查询时,改列是被现有模式引用时,都可能产生ORA-30746错误。
1.检查要删除的列名是否正确
2.检查要删除的列在该表中是否存在
3.检查要删除的列是否被外键关联
4.使用DROP COLUMN语句删除指定列
5.重新创建表,其中不包含要删除的列