drop user 导致列丢失

数据迁移时，删除某个用户，使用DATAPUMP重导。导致其它用户下引用该用户下自定义类型的表列数据丢失。

问题重现示例

SQL> create user user1 identified by Zas_9999;

User created.

SQL> create user user2 identified by Zas_9999;

User created.


SQL> grant dba to user1;

Grant succeeded.

SQL> grant dba to user2;

Grant succeeded.

SQL> grant EXECUTE ANY TYPE  to user2;

Grant succeeded


SQL> create type user1.type1 as object(c int);
  2  /

Type created.


SQL> create table user2.tab1(id number,c1 user1.type1);

Table created.

insert into  user2.tab1(id,c1) values (1,user1.type1(1));

SQL> commit;

Commit complete.


----查询到1行数据，两列
SQL> select * from user2.tab1;

        ID
----------
C1(C)
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
         1
TYPE1(1)


---drop user cascade 无提示，但实际导致其它用户下的表，列数据丢失了
SQL> drop user user1 cascade;

User dropped.

----查询到1行数据，只有1列，C1 列没了！！！
SQL> SQL> select * from user2.tab1;

  ID
----
   1


复制