Code Listing 2: Getting and setting the instantiation SCN

DECLARE
  source_scn  NUMBER;
BEGIN
  source_scn := DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER();
  DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN@TEST10G2(
    source_object_name    	=> 'scott.emp',
    source_database_name  	=> 'TEST10G1',
    instantiation_scn     	=> source_scn);
END;
/
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy