Skip to main content

Hi All,

I created a Database Link in DEV (Build Place) to link to CFG environment using an end user in CFG.
I can see a valid Database Link in DEV.
However I cannot see created DB link in the application (DEV environment).
Location 
Solution Manager > Data Management > Data Migration Manager > Project Basic Data Setup/Connected environments tab/Database Link name.
Any idea as to why I cannot see the DB link from the application

 


 

Hi,
used LOV is based on this view: 

CREATE OR REPLACE VIEW DATABASE_LINKS_LOV AS
SELECT a.db_link database_link_name
FROM dba_db_links a
WHERE a.username = 'IFSMIG'
WITH READ ONLY;

So you have to create that DB link under user IFSMIG.
When is app IFS hosted, then it should be done by IFS.

BR
Filip


Hi @InfFilipV ,

You are correct. IFS should do it. However, IFS insist they can only create a DB link from a Prod to a non Prod environment.
but my requirement is to push data from a non Prod to a non Prod for testing.
Without this , Data Migration Manager is useless.


Reply