streams ora-23621 - transport tablespace

From: geraldine <geraldine_1_at_comcast.net>
Date: 1 Oct 2005 15:29:44 -0700
Message-ID: <1128205784.585165.4710@g14g2000cwa.googlegroups.com>

I tried to transport a tablespace from one db to another using Streams on 10.2.0.1. Anyone knows why I'm getting the error below? Was not able to find much information on ora-23621.

SQL> begin
2 dbms_streams_adm.maintain_simple_tablespace( 3 tablespace_name=>'USERS',
4 source_directory_object=>'SOURCELOC',
5 destination_directory_object=>'DESTLOC', 6 destination_database=>'DEST.XYZ.COM',
7 setup_streams=>true,
8 bi_directional=>true);
9 end;
10 /
begin
*
ERROR at line 1:
ORA-23621: Operation corresponding to script 021830C1899EA78DE040A8C0A1003EE0
is in progress.

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 2328
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7451
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2324
ORA-06512: at line 2

thanks.

Geraldine Received on Sat Oct 01 2005 - 17:29:44 CDT