- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 65 Insurance
- 536.7K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Behaviour of Public Database Links/Public synonyms in Multi tenant architecture
I need little help in this knowledge area of Multi tenant architecture of Oracle Database R12.2.
In our organization we have not implemented this architecture yet.
I have few questions lingering in my mind about:
1.What happens to Public Database links. Suppose if I clone a PROD Database to QA/DEV, does the
Public Database links are also cloned. When they are cloned, how I can handle them in
QA/DEV environment. Those links still point my PROD database ?
Can I clone PROD Database to QA/DEV/someother DB, everything with the exception of like Public Database Links/
2.What happens when using public synonyms in pluggable databases? Do other databases see those objects?
3.What are advantages/disadvantages using pluggable databases.
Please help me. Thanks in advance