Oracle Streams
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle Streams

  1. #1
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995

    Oracle Streams

    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.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    I remember when this place was cool.

  3. #3
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    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.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  5. #5
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  6. #6
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    bummer doood
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width