8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Oracle Streams


haley said...

tks a lot. it's very helpful for me.

Reza Rawassizadeh said...

I look for short and complete example and I found it here

Nick Williamson said...

Absolutely fantastic article! *Exactly* what I was looking for... a proof of concept for one-way Streams-based replication on a single table. I'd struggled with the examples in the Oracle manuals but Tim's stuff worked first time, and really got me out of a hole. Thanks for posting it...

Mike said...

Perfect write-up. I needed a quick one table example so I could get it going and look at the dictionary tables, etc.

Thanks!

satish said...

I tired this example, it worked perfectly fine. however now I get an error in destination database sys.apply$_error table as "table or view does not exist"

Please advice

Kal said...

This worked from scratch for a 10G database, perfect, thanks a lot.

Vimal said...

Hi Tim, It would be very helpful if you tell me if the procedure is same for 10g also? Shall I do the similar for 10g?

waiting for reply,
Vimal.

Damian said...

Nice article Tim. I see now Oracle Streams are deprecated in 12c. Is there another way of doing this in future maybe with Xstreams?

Tim... said...

Hi.

The Oracle stance is you should use Golden Gate, but that costs a lot of money, so people are not too happy about this.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.