Skip to Main Content

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!

Oracle Streams - beginner

640994May 23 2008 — edited May 29 2008
I am new on DBA side, have a few experience.

So, I am research Oracle Streams.
Have a book and strarted to read it.
So, I have some question, and I will be happy if you answer these.

1. I think Oracle streams is enhancement Oracle replication, am I right?
2. Also different between streams with replication, replication only does between Oracle products, but steams are either (oracle prod and non oracle prod) am I right?
3. I did step by step as under the link http://blogs.ittoolbox.com/oracle/guide/archives/oracle-streams-configuration-change-data-capture-13501

But at the end:

SQL> SELECT employee_id, first_name, last_name, upd_Date, action
2 FROM hr.employee_audit ORDER BY employee_id;
no rows selected

SQL> disc
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> conn strmadmin/strmadmin
Connected.

SQL> set long 9999
SQL> set pagesize 0
SQL> select * from streams_monitor;
no rows selected

SQL>

Where is result?

Note: my hr.employees table I inserted 211 (employee_id) and my hr.employees table has additional field, I inserted with NULL value

sqlplus hr/hr
INSERT INTO hr.employees VALUES(211, 'JOHN', 'SMITH',
'JSMITH@MYCOMPANY.COM',
NULL, '07-JUN-94', 'AC_ACCOUNT', 777, NULL, NULL, 110, NULL);
COMMIT;
UPDATE hr.employees SET salary=5999 WHERE employee_id=206;
COMMIT;
DELETE FROM hr.employees WHERE employee_id=211;
COMMIT;


Please help me understand Streams, soon I will go to course ImplementStreams10g. Until this I want to study some necessary thing for Oracle Streams.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2008
Added on May 23 2008
8 comments
1,935 views