RE: Streams for one-time single source replication

> How big is the entire database vs. the subset of schemas?

Entire DB (incl temp, undo, system, etc) is ~1TB. Subset of schemas is 800GB, with a lot of whitespace in there.

> Also, I don't want to discourage you from Steams altogether. I had
> originally assumed you would want the whole database kept in sync which
> would have made DataGuard the obvious choice for me.

I have actually setup both a physical and logical standby, but it was a lifetime ago (8 years?) and I left that job before that project was completed. "Use it or lose it" applies, I guess. :)

Thanks!
Rich

--
http://www.freelists.org/webpage/oracle-l