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)

Table import and export.

Create Data Pump Directory. The first step in Oracle Data Pump is to create an OS level directory which will be used by Oracle for perform...

  • 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...
  • 12.1 Architecture
    APPS DBA- DOCUMENT  3 Tier architecture:             Desktop Tier  For Desktop tier We need  sun JRE plug-in component and it’s invo...