Drop Database Links

After you create a database link you can drop the database link.

1. Drop a database link to a target database using DBMS_CLOUD_ADMIN.DROP_DATABASE_LINK.

   For example:

   BEGIN
        DBMS_CLOUD_ADMIN.DROP_DATABASE_LINK(
             db_link_name => 'SALESLINK' );
   END;
   /

2. Include the public_link parameter when the database link is a public database link.

   For example:

   BEGIN
        DBMS_CLOUD_ADMIN.DROP_DATABASE_LINK(
             db_link_name => 'SALESLINK'
             public_link => TRUE);
   END;
   /

   To run DBMS_CLOUD_ADMIN.DROP_DATABASE_LINK with public_link set to TRUE, you must have the DROP PUBLIC DATABASE LINK system privilege.

See DROP_DATABASE_LINK Procedure for detailed information about the procedure.