Generating DDL Script for all objects in a schema which uses DBlink in its code
Hi,
We had two main schemas in two different database. The schemas are: HISPT and CISPT. The objects were using DBlinks in its codes in both the schemas to connect each other (CIS_HMS for CISPT--> HISPT and HMS_CIS for HISPT-->CISPT). Now the schemas are being planned to bring together inside a same database. So we need to identify which objects are using the DBlink in their codes and we need to recreate the objects without Dblink.
I thought of a query using DBA_SOURCE view internally (I thought this particluar view is the best one to provide me the desired result) for it:
We had two main schemas in two different database. The schemas are: HISPT and CISPT. The objects were using DBlinks in its codes in both the schemas to connect each other (CIS_HMS for CISPT--> HISPT and HMS_CIS for HISPT-->CISPT). Now the schemas are being planned to bring together inside a same database. So we need to identify which objects are using the DBlink in their codes and we need to recreate the objects without Dblink.
I thought of a query using DBA_SOURCE view internally (I thought this particluar view is the best one to provide me the desired result) for it:
0