I am in Oracle Apps 11.5.10 environment. After cloning (Apps & Database) from production to development.
I checked :
SELECT * FROM USER_DB_LINKS under APPS
I get the following output:
DB_LINK USERNAME PASSWORD HOST
APPS_TO_APPS APPS appsProdPwd PROD
APPS_TO_APPS.MYDOMAIN.US.COM APPS appsDevPwd DEV
EDW_APPS_TO_WH APPS appsProdPwd PROD
EDW_APPS_TO_WH.MYDOMAIN.US.COM APPS appsDevPwd DEV
When I try to drop the database link:
DROP DATABASE LINK APPS_TO_APPS
DROP DATABASE LINK APPS_TO_APPS.MYDOMAIN.US.COM
The database link APPS_TO_APPS.MYDOMAIN.US.COM is dropped and APPS_TO_APPS pointing to PROD still remains. How do I drop these two database links
APPS_TO_APPS and EDW_APPS_TO_WH which points to PROD
After cloning, I ran FND_CONC_CLONE.SETUP_CLEAN;
commit; and ran autoconfig. But it doesn't help.
Can anyone help me in resolving this?
Thanks in advance
I have posted this query in other forums also and haven't got a solution.