Oracle Streams

[OracleDoc]

ok guys I'm looking for some good documentation on the subject.

I've found that streams can be used from non-oracle databases to Oracle but, I want to know it will work considering that streams depend on logging and in my case, I'm looking at DB2 going to Oracle. How in the heck can that work if there is no type of Oracle logging going on in DB2.

[Mr.Hanky]

http://otn.oracle.com/oramag/webcolu...l_streams.html


Any good?
There is a DB2 section as well on http://www.dbazine.com/db2.shtml

MH

[OracleDoc]

thanks doood.

I already looked at the article on the orcle url. It didn't say anything how it goes about getting the data from a non-oracle database.

I also looked at the db2 site and it didn't have anything on there about oracle streams (at least when I did a search on the page for it. that damn thing was longgg).

I'm getting kind of fustrated on this because everything I find just says what it does and how it goes about getting the data. I haven't found anything that says if you're wanting data from this particular kind of database do this.

[KenEwald]

Looks like it's done through the Oracle Transparent Gateway for
name_your_db then treated as just another oracle database.

Check out the white papers and ppt's from OracleWorld San Fran

www.oracle.com/oracleworld then search on streams. Presentation 40208 has a good section on non-oracle db's.

[OracleDoc]

Ahhh according to that document it says...

NON-ORACLE TO ORACLE CAPTURE/APPLY
Users who want to propagate changes from a non-Oracle database to an Oracle database must write an application to capture the changes made to the non-Oracle database. The application can capture the changes by reading from transaction logs or by using triggers. The application is then responsible for assembling and ordering these changes into transactions, converting them into an LCR format and publishing them into the target Oracle database staging area.


Well that about sucks lol.

[KenEwald]

bummer doood