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 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- Niall Litchfield Oracle DBA http://www.orawin.info