Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Repository migration from 2.1.2 onto 6.5

19659Oct 2 2001
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 30 2001
Added on Oct 2 2001
0 comments
100 views