Home » Server Options » Streams & AQ » Copy base data (oracle 9I to oracle 10)
Copy base data [message #359520] Mon, 17 November 2008 01:44 Go to next message
yechiel
Messages: 7
Registered: November 2008
Location: Israel
Junior Member
Is there a way to tell streams to copy the existing rows in the table when I start/define the capture process?
I want to copy a full 9i database to 10g using streams.
Re: Copy base data [message #359598 is a reply to message #359520] Mon, 17 November 2008 09:45 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Use exp/imp to acheive this.
Regards,
Varun Punj
Re: Copy base data [message #359601 is a reply to message #359598] Mon, 17 November 2008 09:56 Go to previous message
yechiel
Messages: 7
Registered: November 2008
Location: Israel
Junior Member
I can not use export as this is a 3TB database.
I think that I saw somewhere that streams can also copy the existing data while the database is working.
This way there will be no down time.
Previous Topic: Shutting down destination server in stream replication
Next Topic: Regarding adding subscriber to queue -- ISSUE
Goto Forum:
  


Current Time: Thu Mar 28 08:18:53 CDT 2024