If a user has a specific role I need to capture that in a session variable. The way that I have this setup is that a 0 will be returned if the role was not listed in the ROLES session variable or a value greater than 0 would be set if the role existed. The session variable is going to be read by the Oracle database to…

Here is how I got around this (combination of Christian's recommendation) and other efforts: * Copied the XML of the old schema to Notepad (this included schema name, physica and alias table definitions) * In notepad renamed the reference of the one schema to the the new schema * Copied the XML from Notepad and pasted into…

Thanks for the confirming what we have been seeing. The odd thing about this is that: 1) I can copy the physical table definitions from one schema to the other it is only the aliases that I cannot copy. At first I thought it would be a dependency issue, so I copied the physical definitions and then tried to copy the…

Can you point me to the location where Sample App v511 is located? Thanks...

To clarify: I want to copy both the physical table definitions and the aliases from the one schema to the second schema. Regarding # 1 - I'm not sure how duplicating the schema will solve the problem sense I have to actually merge the two schemas. It is not allowing me copy/move table and alias definitions from one schema…

I apologize but you are correct we are moving form 11g to 12c.