Oracle Repository migration from 2.1.2 onto 6.5
Being under process of migration described in the subject I ran
into a problem. The generated script (migrate_repos_privs.sql)
intending to register dependent users in the new repository
popped up with the following error:
...
Creating sub-ordinate user DES_OLD
declare rtnval number;
*
ERROR at line 1:
ORA-22863: synonym for datatype DES6I_OWNER.SDD_SYS_PRIV_LIST
not allowed
...
I checked if there was such a synonym, but was only able to find
an array type with the same name within the repository owner's
schema.
Does anybody know what has happened ?
Can I perform migration onto the repository owner's schema with
a name being different to the original one while preserving the
names of dependent users ?
Thanks.