Oracle Application DBA Information

Friday, 10 August 2018

How to Take Backup Database Link In Oracle 10g,11g,12c

For All DB links backup:
---------------------
set pages 0
set long 90000
set trimspool on
SELECT u.OWNER,DBMS_METADATA.GET_DDL('DB_LINK',u.DB_LINK,u.OWNER) FROM dba_db_links u;

For All Specific DB link backup:
---------------------------------
set pages 0
set long 90000
set trimspool on
SELECT DBMS_METADATA.GET_DDL('DB_LINK','&DB_LINK_NAME','&USER_NAME') FROM dba_db_links;
Posted by appsdba.furqan at 04:39 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)
appsdba.furqan
View my complete profile

Blog Archive

  • ►  2024 (15)
    • ►  February (1)
    • ►  January (14)
  • ►  2023 (4)
    • ►  December (4)
  • ►  2021 (1)
    • ►  May (1)
  • ►  2020 (15)
    • ►  November (5)
    • ►  September (7)
    • ►  August (1)
    • ►  January (2)
  • ►  2019 (30)
    • ►  November (1)
    • ►  October (2)
    • ►  September (2)
    • ►  June (14)
    • ►  May (3)
    • ►  April (7)
    • ►  January (1)
  • ▼  2018 (13)
    • ▼  August (1)
      • How to Take Backup Database Link In Oracle 10g,11...
    • ►  July (1)
    • ►  June (11)
  • ►  2017 (31)
    • ►  December (2)
    • ►  November (22)
    • ►  March (7)
  • ►  2016 (66)
    • ►  October (9)
    • ►  August (4)
    • ►  July (19)
    • ►  May (34)
Simple theme. Powered by Blogger.