Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

A few general questions about Oracle Streams for oracle 10.2.0.4

Edward lzAug 1 2025

Hi all. I ask the experts to answer a few of my questions.

There is a task to install and configure Oracle Streams on Oracle 10.2.0.4. I know this is a very old version, but this is the version I need. In this regard, I have several questions:

  1. Is it true that not every installation included Oracle Streams? I have oracle 10.2.0.4 x64 but with advanced installation I don't see Oracle Streams in the components..

  2. Is it true that using this sql query you can check whether Oracle Streams is installed?

    SELECT * FROM dba_registry WHERE comp_name LIKE '%Streams%';

  3. Is it true that the Primary Key in the tables that Oracle Stream will work with is a mandatory requirement for Oracle Stream to work?

  4. Does Oracle Streams work with blob fields?
Comments
Post Details
Added on Aug 1 2025
2 comments
51 views