Re: Oracle streams between 9i and 10g

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Tue, 07 Oct 2008 07:51:55 +0200

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@xxxxxxxxxxxx <mailto:Mark.Bobak@xxxxxxxxxxxx>> 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@xxxxxxxxxxxx <mailto:mark.bobak@xxxxxxxxxxxx>
    www.proquest.com <http://www.proquest.com/>
    www.csa.com <http://www.csa.com/>

    ProQuest...Start here.

    -----Original Message-----
    From: oracle-l-bounce@xxxxxxxxxxxxx
    <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
    [mailto:oracle-l-bounce@xxxxxxxxxxxxx
    <mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On Behalf Of Bort, Guillermo
    Sent: Monday, October 06, 2008 9:23 AM
    To: adar666@xxxxxxxxxxxx <mailto:adar666@xxxxxxxxxxxx>
    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

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


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





--
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2008