So there I was, working on another database duplication project, the requirement is to save the existing database links.
Sounds pretty easy, right?
SELECT OWNER, DB_LINK, DBMS_METADATA.GET_DDL('DB_LINK',DB_LINK,OWNER) as DDL FROM DBA_DB_LINKS;
Wrong and I know why I am getting bald. Pulling my hair out.
After searching for hours, I found DBMS_METADATA.GET_DDL database link password missing
Another 220.127.116.11 Bug.
I believe the bug was introduced when I modified user’s password as shown below since everything was working fine just hours ago.
alter user SCOTT identified by values 'S:EDCCC6A91707D978B7D49476BCA228BC7D702C135557F41154ACBF744645;F894844C34402B67';
Got desperate and restored the database which did not help.
Now what and how is one suppose to save database links info?
Find out more here