ORA-02303: cannot drop or replace a type with type or table dependents

ORA-02303: cannot drop or replace a type with type or table dependents
Cause: An attempt was made to drop or replace a type that has type or table dependents.
Action: For DROP TYPE, drop all type(s) and table(s) depending on the type and then retry the operation, or use the FORCE option. For CREATE TYPE, drop all type(s) and table(s) depending on the type and then retry the operation, or drop all table(s) depending on the type and retry with the FORCE option.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-02303：不能删除或替换类型或表依赖关系的类型,
.原因：试图删除或替换具有类或表依赖关系的类型。,
.操作：对于DROP TYPE，根据类型删除所有类型和表，然后重试操作，或使用FORCE选项。对于CREATE TYPE，根据类型删除所有类型和表，然后重试操作，或根据类型删除所有表，并使用FORCE选项重试。,
.

aiaiDBA

13718043309

010-86462881

ORA-02303: cannot drop or replace a type with type or table dependents

1 个回答

相似问题