"Error Collection" error during Oracle build stream

Error one: After configuring the source and target databases, create a replication administrator. After you connect the replication administrator, perform the maintain_table process in the Source library:

declare v_tables dbms_utility. Uncl_array;begin V_tables (1) :='hr.test01'; V_tables (2) :='hr.test02'; V_tables (3) :='hr.test03'; Dbms_streams_adm.maintain_tables (Table_names=V_tables, Source_directory_object=NULL, Destination_directory_object=NULL, Source_database='orcl.net', Destination_database='weber.net', Perform_actions=true, Bi_directional=true, Include_ddl=true, instantiation=dbms_streams_adm.instantiation_table_network); end;/

I found this error:

I found this error:

ERROR at line1: ORA-23616: FailureinchExecuting block A  forScript06f6bbb2e70137c5e05054b4f621416cora-06512: at"SYS. Dbms_recoverable_script", line593ORA-06512: at"SYS. Dbms_recoverable_script", line616ORA-06512: at"SYS. DBMS_STREAMS_MT", line7747ORA-06512: at"SYS. Dbms_streams_adm", line2458ORA-06512: At line7

Solution:

Solution:

By capturing the execution script of the source library, the error ID is found to be the first few steps to perform the error

SelectInvoking_package_owner asowner, Invoking_package asPackage , Invoking_procedure asprocedure, status, Total_blocks, Done_block_num fromDba_recoverable_script8   wherescript_id ='06f6bbb2e70137c5e05054b4f621416c'  9; OWNER Package------------------------------ ------------------------------PROCEDURE STATUS total_blocks done_block_num------------------------------ ------------ ------------ --------------SYS dbms_streams_admmaintain_tables ERROR -          +

Find out what the reason is:

Select error_number, Error_message    from dba_recoverable_script_errors   3   where ' 06f6bbb2e70137c5e05054b4f621416c ' and block_num=; Error_number------------error_message-------------------------------------------------------- ------------------------      -25153ORA-25153 is Empty

The original is a temporary table space error report empty. Then check the source library for temporary file conditions, the results show that there are. That's a wonder.

Select  from dba_temp_files   2   ; Tablespace_name------------------------------file_name------------------------------------------ --------------------------------------TEMP/u01/app/oracle/oradata/orcl/temp01.dbf

Look again at the temporary files for the target database:

Select  from v$tempfile;no rows selected

Rub, incredibly did not, this time can basically find out is this problem. It would be nice to add the temporary files of the target database.

' /u01/app/oracle/oradata/weber/temp01.dbf ' ; Tablespace altered.

Perform the maintain_table process again in the Source library. OK, found no error!

"Error Collection" error during Oracle build stream