| hkdty228 | 
		
			
				 Wysłany: Nie 10:05, 29 Maj 2011    Temat postu: monster beats by dr. dre oracle 10g Streams enviro | 
			 
			
				
  | 
			 
			
				6, configured in racdb2 apply - application process 
  conn strmadmin / strmadmin 
  BEGIN 
  DBMS_STREAMS_ADM.ADD_SCHEMA_RULES (
  schema_name => 'hr', 
  streams_type => 'apply', 
  streams_name => 'apply_racdb2',monster beat, 
  queue_name => 'strmadmin.racdb2_queue', 
  include_dml => true, 
  include_ddl => true, 
  source_database => ' racdb1 '); 
  END; 
  / 
  
  set disable error,monster beats by dr. dre,beats studio 2011-4-20, when an error occurs apply process does not stop 
  conn strmadmin / strmadmin 
  BEGIN 
  DBMS_APPLY_ADM.SET_PARAMETER (
  apply_name => 'apply_racdb2', 
  parameter => 'disable_on_error', 
  value => 'n'); 
  END; 
  / 
  
  7, in racdb2 start the apply process 
  conn strmadmin / strmadmin 
  BEGIN 
  DBMS_APPLY_ADM.START_APPLY (
  apply_name => 'apply_racdb2'); 
  END; 
  / 
  
  8, start the capture process in racdb1 
  conn strmadmin / strmadmin 
  BEGIN 
  DBMS_CAPTURE_ADM.START_CAPTURE (
  capture_name => 'capture_racdb1'); 
  END; 
  / 
  Note : propagation process is created by default from the start, that did not start to manually start : 
  BEGIN 
  DBMS_PROPAGATION_ADM.START_PROPAGATION (
  propagation_name => 'racdb1_to_racdb2'); 
  END; 
  / 
  
  ok,beats by dr dre headphone, stop here , streams have been configured . Adopted in the racdb1 hr user performs related ddl, dml operation, the results can be seen on the racdb2 . 
  
  IV summarizes the main 
  above steps are given in detail , without adding too many notes, please refer to the conceptual things oracle documentation. Personal feeling to master a new technology is better : google specific article , but because of the environment vary widely , in all likelihood be unreasonable ; then carefully study the document oracle , E wen we all looked tired, but this is the most More , the most comprehensive ; perseverance, find ways to get it, may two or three hours ,beat by dre headphone 2009 intrepid, probably two or three days ,beats by dre tour headphones June 2010 25-26 Two-day tour of Shijiazhuang Shanxi, may also be two or three weeks , but must do it , drop out is to destroy confidence . | 
			 
		  |