ORA-42287: cannot rename user on whose type a table depends

ORA-42287: cannot rename user on whose type a table depends
Cause: An attempt was made to rename a user whose schema contained a type on which some table depends. The operation may not proceed as it would render the table invalid causing loss of data.
Action: Drop table(s) dependent on types belonging to the schema of the user being renamed.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:53

ORA-42287：无法重命名表所依赖的类型的用户,
.原因：尝试重命名其模式包含某个表所依赖的类型的用户。操作可能无法继续，因为它会导致表无效，导致数据丢失。,
.操作：删除依赖于属于要重命名的用户的模式的类型的表。,
.

aiaiDBA

13718043309

010-86462881

ORA-42287: cannot rename user on whose type a table depends

1 个回答

相似问题