Re: Oracle streams between 9i and 10g

This is a database the size of about 1 TB. This database is used in the bank branches during the day and is updated with batch run during the night, so import/export is out of the question. I have a test system to check this up, so I will try it in the next weeks and tell you if it worked.

Adar Yechiel
Rechovot, Israel

Niall Litchfield wrote:
> In addition you can in theory do most of the work on the new database
> and leave pretty much only set up of the redo movement, the
> supplemental logging and the instantiation to happen from there. There
> were a lot of data type restrictions though, and I can't actually get
> the above setup to work between 2 10gr2 databases right now, so export
> might not be a bad plan!
>
> On Mon, Oct 6, 2008 at 2:44 PM, Bobak, Mark <Mark.Bobak_at_proquest.com
> <mailto:Mark.Bobak_at_proquest.com>> wrote:
>
> Streams is definitely in 9i. I've never used it, and from what I
> read, it wasn't exactly fully baked....but it's there....
>
> http://download.oracle.com/docs/cd/B10501_01/server.920/a96524/c01_02intro.htm#56463
>
>
> -Mark
>
> --
> Mark J. Bobak
> Senior Database Administrator, System & Product Technologies
> ProQuest
> 789 E. Eisenhower, Parkway, P.O. Box 1346
> Ann Arbor MI 48106-1346
> +1.734.997.4059 or +1.800.521.0600 x 4059
> mark.bobak_at_proquest.com <mailto:mark.bobak_at_proquest.com>
> www.proquest.com <http://www.proquest.com/>
> www.csa.com <http://www.csa.com/>
>
> ProQuest...Start here.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>
> [mailto:oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>] On Behalf Of Bort, Guillermo
> Sent: Monday, October 06, 2008 9:23 AM
> To: adar666_at_inter.net.il <mailto:adar666_at_inter.net.il>
> Cc: ORACLE-L
> Subject: RE: Oracle streams between 9i and 10g
>
> I am not aware of any stream capability in Oracle9i, AFAIK it's a 10g
> Feature
>
> Guillermo Alan Bort
> EDS - ITO DBA Main Group
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info

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