This DML feature introduced in Oracle 19c, this includes DML statements that are part of PL/SQL blocks.
The DML on the standby database will have below steps
- The user executes DML against open standby database.
- DML will be automatically redirects to the primary database.
- The DML will be applied on the primary Datable
- The redo info related change is streamed back to the standby database.
- The application change based redo info completes the DML and data is available for the client.
1. The DML Redirect can be configured at system level, this will apply to all sessions connection to the standby database
Run below command for SYSTEM LEVEL DML Redirection
SQL> ALTER SYSTEM SET ADG_REDIRECT_DML=TRUE SCOPE=BOTH;
2. You can overwrite the system level parameter with alert session command to enable the DML redirect for the current session only.
SQL> ALTER SYSTEM SET ADG_REDIRECT_DML=TRUE SCOPE=BOTH;
2. You can overwrite the system level parameter with alert session command to enable the DML redirect for the current session only.
Run below command to enable SESSION LEVEL DML Redirection
SQL>ALTER SESSION ENABLE ADG_REDIRECT_DML;
Thanks & Regards
http://oracleracexpert.com
Get Shifting/Relocation Quotation from ###Packers and Movers Delhi. Packers and Movers Delhi 100% Affordable and Reliable ***Household Shifting Services. Compare Transportation Charges and Save Time, Verified and Trusted Packers and Movers in Delhi, Cheap and Safe Local, Domestic House Shifting @ Packers And Movers Delhi
ReplyDeletePackers and Movers Gurgaon Provide Reliable, Safe and Certified Service Provider list, Get Free ***Best Price Quotaition and Compare Charges. ???Hassle free Household Shifting Services, High Quality packing Material, Office Relocation, Car Transportaion, ###Local and Domestic Shifting Service @ Packers And Movers Gurgaon
ReplyDeleteIt's really amazing to have many lists of will help to make thanks a lot for sharing
ReplyDeletevé máy bay đi nha trang tháng 10
vé máy bay khứ hồi hà nội phú quốc
vé máy bay đi phù cát
vé máy bay từ hà nội đi đà lạt vietnam airlines
combo du lịch đà nẵng
Hey!Amazing work. With full of knowledge. Our Team resolve any glitches occurring while utilizing the software. Looking for Quickbooks Error Support Contact us (877) 606-0004.Our experts will assist you to fulfil your accounting needs. The solutions are accurate and time-saving.
ReplyDeletePackers and Movers Chennai Give Safe and Reliable ***Household Shifting Services in Chennai with Reasonable ###Packers and Movers Price Quotation. We Provide Household Shifting, Office Relocation, ✔✔✔ Local and Domestic Transportation Services, Affordable and Reliable Shifting Service Charges @ Packers And Movers Chennai
ReplyDeletePackers and Movers Hyderabad Give Certified and Verified Service Providers, Cheap and Best ###Office Relocation Charges, ***Home Shifting, ✔✔✔Goods Insurance worth Rs. 10,000, Assurance for Local and Domestic House Shifting. Safe and Reliable Household Shifting Services in Hyderabad with Reasonable Packers and Movers Price Quotation @ Packers And Movers Hyderabad
ReplyDeleteWe are the best Provider Escorts Service in Nashik. Our call girls are the best in terms of sexual satisfaction with full pleasure, they are well qualified and professional working. Nashik Escorts |
ReplyDeleteNashik Call Girls
´´´´´████████´´´´
´´`´███▒▒▒▒███´´´´´
´´´███▒●▒▒●▒██´´´
´´´███▒▒▒▒▒▒██´´´´´
´´´███▒▒💋▒▒██´
´´██████▒▒███´´´´´
´██████▒▒▒▒███´´
██████▒▒▒▒▒▒███´´´´
´´▓▓▓▓▓▓▓▓▓▓▓▓▓▒´´
´´▒▒▒▒▓▓▓▓▓▓▓▓▓▒´´´´´
´.▒▒▒´´▓▓▓▓▓▓▓▓▒´´´´´
´.▒▒´´´´▓▓▓▓▓▓▓▒
..▒▒.´´´´▓▓▓▓▓▓▓▒
´▒▒▒▒▒▒▒▒▒▒▒▒
´´´´´´´´´███████´´´´
´´´´´´´´████████´´´´´´
´´´´´´´█████████´´´´´
´´´´´´██████████´´´
´´´´´´██████████´´
´´´´´´´█████████´
´´´´´´´█████████´
´´´´´´´´████████´´´
________▒▒▒▒▒
_________▒▒▒▒
_________▒▒▒▒
________▒▒_▒▒
_______▒▒__▒▒
_____ ▒▒___▒▒
_____▒▒___▒▒
____▒▒____▒▒
___▒▒_____▒▒
_███______▒▒
█_███____███
█__███_ _█_███
█ ███
Wonderful post,This article have helped greatly continue writing...
ReplyDeleteHIV/AIDS Complete cure test result in Tamilnadu | Hiv aids treatment in bangalore
Best hiv doctor in india | Hiv positive treatment in india
Medicine for aids in india | HBSag complete cure for Herbal in india
This is a brilliant article, Given such a great amount of data in it, These kind of articles keeps the clients enthusiasm for the site, and continue sharing more
ReplyDelete360DigiTMG data analytics course
Good information you shared. keep posting.
ReplyDeletedata science malaysia
Very interesting and thanks for sharing such a good blog. keep sharing.
ReplyDeletebest machine learning course in aurangabad
Really Nice Information It's Very Helpful All courses Checkout Here.
ReplyDeletedata science courses
Interesting stuff to read. Keep it up.
ReplyDeleteAdidas showroom in madurai | Woodland showroom in madurai
Puma showroom in madurai | Crocs showroom in Madurai
This is also a very good post which I really enjoyed reading. It is not every day that I have the possibility to see something like this..
ReplyDeletedata science certification
I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.I want to share about
ReplyDeletemachine learning training in aurangabad
Порно видео онлайн бесплатно тут Жену в жопу
ReplyDeleteСмотрите каждый день Русское порно онлайн бесплатно
Great Post for Beginner to understand.
ReplyDelete바카라사이트
Best Casino Hotel St. Louis in St. Louis
ReplyDeleteBest Casino Hotel St. Louis, MO. 3131 Saint Louis 서귀포 출장샵 Blvd. 양산 출장샵 South Center City, MO 70119. 계룡 출장마사지 The Best Casino Hotel St. Louis is 대구광역 출장샵 located nearby to the airport. 상주 출장마사지
ReplyDeleteI appreciated looking at your article. Very wonderful reveal. I would like to twit this on my followers. Many thanks!
bulletintech
whizzherald
talesbuzz
alternativestips
shindigweb
gettechexpert
I appreciated looking at your article. Very wonderful reveal. I would like to twit this on my followers. Many thanks!
ReplyDeletetoponlinegeneral
rustwire
toponlinegenerals
techwithgeeks
versionate
alltechpride
The games and the referral program through Jaa Lifestyle are one simple way of earning money online. Individuals can earn extra bucks by just spending their time on Jaa Lifestyle website and get actually involves in the flow. As well there are few option such as to watch the ads, refer friends and use other options from the website which also does earn money. Jaa Login There are various ways Jaa Lifestyle provides money to individuals by just watching or using the services from it.Individuals to access Jaa Lifestyle website, they need to have got themselves register with the website through the official process. Here are the steps that you can follow to get access to Jaa Lifestyle Login ID.
ReplyDelete