using oracle 11g express r2 migrated from mssql2005
sql devloper creates "utils" snonyms ,tables and packages while migrating, i want to have the same thing on other schema.
how can i have it. i have created the public synonym also but it is asking for table , where can i find the table pls tel me.
Edited by: 944768 on Apr 4, 2013 12:23 AM
Edited by: 944768 on Apr 4, 2013 4:50 AM
Edited by: 944768 on Apr 6, 2013 1:36 AM
It is not very clear what you are asking for. If you want to copy the supporting objects created by the migration process, I wouldn't be at all surprised if that was in violation of the license.
More generally, synonyms are useless on their own - they require the underlying objects, and privileges on those objects to be useful.