1 person found this helpful
> 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 ?
Yes, they will. But you can change/re-create them after cloning with an AFTER-CLONE-Trigger which is fired in the new PDB,
> Can I clone PROD Database to QA/DEV/someother DB, everything with the exception of like Public Database Links/
No, but you can drop the Public DB Links after cloning using an AFTER-CLONE-Trigger.
> 2.What happens when using public synonyms in pluggable databases? Do other databases see those objects?
> 3.What are advantages/disadvantages using pluggable databases.
There are multiple articles on blog posts on this topic.
Try your favourite search engine or start with this one:
Thanks Markus, appreciates your response.
Hi Sada V,
A database link is created by executing a SQL statement. Therefore, such a statement must produce the same result in a PDB as it does in a non-CDB. By extension, you can create a database link from a PDB to a non-CDB, or from a non-CDB to a PDB — and these can cross a difference in Oracle Database software version in the same way as is supported between two non-CDBs.
Please mark your question as answered or helpful if you find the above solution useful / correct, so that other community members can find the information easily. See Did Your Question Get Answered in My Oracle Support Community Note 1180503.1 document on how to do this.