I think that must be it. i once tried the declarative rule based transformation for renaming schema but didn't get to work. May be i will try again with these procedures today. Thanks, Stalin On Mon, Sep 22, 2008 at 6:45 AM, Roman Podshivalov <roman.podshivalov@xxxxxxxxx> wrote: > Hi, > > Did you check the following metalink notes on how to transform schema name > in streams setup ? > > Note:309575.1 > Note:264035.1 > --romas > > On Thu, Sep 18, 2008 at 9:05 PM, Stalin <stalinsk@xxxxxxxxx> wrote: >> >> All, >> >> Anyone with 2 apply queues in destination site with different subset >> rules had trouble getting it to work? I'm trying to stream a capture >> queue with 2 propagation process each having its own subset rules off >> the same capture queue from a source database to a remote database in >> separate schema's with 2 different apply queues. I can see the >> messages are queued to appropriate apply queues at destination site, >> but when it comes to applying it, schema2 data goes schema1. However >> schema1 messages goes to schema1 as expected. >> >> Any ideas? >> >> Thanks, >> Stalin >> -- >> //www.freelists.org/webpage/oracle-l >> >> > > -- //www.freelists.org/webpage/oracle-l