Hello everyone!
We have an Oracle DB 11gR2 which is used to store the EBS data.
Inside that DB, we also have a schema called EX to store our custom tables, views, etc...
Many of our developments (PL/SQLs, APEX) use the EX schema objects.
Our boss has requested to separate the EX schema, I mean, export the EX schema and import it into a new Oracle DB.
We don't want to modify our PL/SQL code because that implies execute long testings, many hours of effort... what is the best way to "repoint" our code without make changes? is it possible not use DB links?
We have thought about create a public DB link to the new database, then create a synonym to the schema (the whole schema not to a specific schema object), but it doesn't work properly..
Is it possible to block or "hide" (disable) the EX schema in the current DB and then use the new schema (remote database)?
We appreciate any help.
Thanks in advance.