OraFAQ Forum: Streams & AQ » Oracle Streams to Flat file or named pipe

Home » Server Options » Streams & AQ » Oracle Streams to Flat file or named pipe

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Streams to Flat file or named pipe [message #75762]

Fri, 07 January 2005 06:19

Eldho Thomas
Messages: 2
Registered: January 2005

Junior Member

I know Oracle Streams is best suited to work between two Oracle databases, but how complex is to use Oracle Streams to stream changed data to a flat file or named pipe instead of an Oracle database ? Is there any additional overhead (processing power, database objects etc.) on the source system in comparison to an Oracle-to-Oracle streaming ?

Can someone explain the specifics of implementing an Oracle-Flat file/Named pipe streaming using Oracle Streams ?

Thanks.

Report message to a moderator

Re: Oracle Streams to Flat file or named pipe [message #75763 is a reply to message #75762]

Mon, 10 January 2005 06:14

Scoop
Messages: 2
Registered: January 2005

Junior Member

I too am interested in the viability of dequeueing the Logical change records created by streams into a flat file. I want to be able to capture the changes but send them via a flat file to target destination at the end of each day.I need to understand if this is possible

Report message to a moderator

Re: Oracle Streams to Flat file or named pipe [message #75766 is a reply to message #75762]

Wed, 26 January 2005 02:14

Scoop
Messages: 2
Registered: January 2005

Junior Member

Eldho,
did you get an answer to the sreams question from any other source?

Report message to a moderator

Re: Oracle Streams to Flat file or named pipe [message #75767 is a reply to message #75766]

Wed, 26 January 2005 06:09

Eldho Thomas
Messages: 2
Registered: January 2005

Junior Member

Nope. But, I think the way it would be done is by using the PL/SQL script at the "APPLY" phase to write into a flat file.

Pls let me know if you hear anything.

Report message to a moderator

Re: Oracle Streams to Flat file or named pipe [message #144433 is a reply to message #75762]

Wed, 26 October 2005 07:50

swetly
Messages: 1
Registered: October 2005

Junior Member

Any feedback on moving the data in flat file??
The problem of using an Apply process is that you must configure a propagation and apply on the same DB. The problem is when you have declared propagation to an remote DB and then the messages are kept in the queue and no one else then the propagation agent can dequeue them Sad

Report message to a moderator

Previous Topic:	how to add include_ddl => true to an existing table which has only include_dml=true
Next Topic:	Oracle Advanced Queuing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 30 06:47:22 CDT 2023