Tuesday, August 31, 2021

generate an dblink

 SELECT DBMS_METADATA.GET_DDL('DB_LINK',db.db_link,db.owner) from dba_db_links db;

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Oracle Database Password Management: Resetting Password Policies and User Account Expiry Issues

  Checking Password Lifetime Policy Oracle password expiration rules are controlled through profiles. The following query helps identify the...

  • TKPROF Overview
      TKPROF Overview.   TKPROF is used for diagnosing performance issues.  It formats a trace file into readable format for performance ana...
  • ORACLE CLOUD EBS INSTALLTION
      CLOUD EBS INSTALLTION   login as: opc Authenticating with public key "rsa-key-20201105" from agent Last login: Thu Nov 19 08...
  • Query to find the Concurrent Request Trace File Path
      Query to find the Concurrent Request Trace File Path In Oracle Applications, we all submit concurrent requests. As a developer when we nee...