886061 wrote:Any operations that will modify or PL/SQL packages changes are not allowed in Read only mode. For that you have to bring in only read n write mode.
We are planning to run pl/sql procedures daily to extract data ( using UTL_FILE ) from physical standby tables and send it to EDW and once the procedure is successful it updates the master table designed for this extract process. Since physical standby is read only..we can not update this table. Is there any way like we can use dblink for accesseing master table present in primary db to update the table from procedure.
Please suggest if there are any other ways.
886061Please keep the forum clean by marking your questions as answered.
Status Level: Newbie
Registered: Sep 19, 2011
Total Posts: 6
Total Questions: 5 (4 unresolved)