OraFAQ Forum: Streams & AQ » Copy base data

Home » Server Options » Streams & AQ » Copy base data (oracle 9I to oracle 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Copy base data [message #359520]

Mon, 17 November 2008 01:44

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.

Report message to a moderator

Re: Copy base data [message #359598 is a reply to message #359520]

Mon, 17 November 2008 09:45

varunvir
Messages: 389
Registered: November 2007

Senior Member

Use exp/imp to acheive this.
Regards,
Varun Punj

Report message to a moderator

Re: Copy base data [message #359601 is a reply to message #359598]

Mon, 17 November 2008 09:56

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.

Report message to a moderator

Previous Topic:	Shutting down destination server in stream replication
Next Topic:	Regarding adding subscriber to queue -- ISSUE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 00:46:07 CST 2025