how to disable or alter database links dba_db_links
Hello,
I am cloning a database instance from production for testing.
1) After cloning, I do not want the dbms_jobs to run on the cloned(testing) database.
2) Also, I want to alter the name of the dba_db_links or even disable them completely.
To resolve for 1), I set the job_queue_processes = 0. So no jobs will run. Is this the best way?
To resolve for 2), I don't know. I am thinking of dropping the dba_db_links, but I don't like doing this because I have to re-create them if I later need to. Is there a way where I can disable the dba_db_links. Or maybe just alter the name of the links to dbLinkName123 so the links would not work.
Thanks.