Oracle Streams - beginner
640994May 23 2008 — edited May 29 2008I 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.