For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
we are tried much time to clone DB, but we are not able to restore it, Now are planning to do Active DB cloning. please if someone has steps for cloning please share with us.
thanks in advance. Chetan yadav
SQL> set serverout on SQL> ed Wrote file afiedt.buf 1 <<outer_block>> 2 declare 3 exc exception; 4 pragma exception_init(exc,-20001); 5 begin 6 <<inner_block>> 7 declare 8 exc exception; 9 pragma exception_init(exc,-20002); 10 begin 11 raise_application_error(-20002,'Error raised'); 12 exception 13 when outer_block.exc then 14 dbms_output.put_line('outer Exception caught ' ); 15 when inner_block.exc then 16 dbms_output.put_line('Inner Exception caught ' ); 17 end; 18* end; SQL> / Inner Exception caught PL/SQL procedure successfully completed. SQL> ed Wrote file afiedt.buf 1 <<outer_block>> 2 declare 3 exc exception; 4 pragma exception_init(exc,-20001); 5 begin 6 <<inner_block>> 7 declare 8 exc exception; 9 pragma exception_init(exc,-20002); 10 begin 11 raise_application_error(-20001,'Error raised'); 12 exception 13 when outer_block.exc then 14 dbms_output.put_line('outer Exception caught ' ); 15 when inner_block.exc then 16 dbms_output.put_line('Inner Exception caught ' ); 17 end; 18* end; SQL> / outer Exception caught PL/SQL procedure successfully completed.