Home » RDBMS Server » Server Administration » Mirroring An Oracle Schema (Oracle 9i,9.2.0.6.0 Windows XP)
Mirroring An Oracle Schema [message #323001] Tue, 27 May 2008 00:55 Go to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Dear All,

What are different methods through which i can Mirror a schema.

Regards,
Rajat Ratewal
Re: Mirroring An Oracle Schema [message #323023 is a reply to message #323001] Tue, 27 May 2008 02:02 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Export /Import is the one that do fine than anything else as far as I know.
Re: Mirroring An Oracle Schema [message #323033 is a reply to message #323023] Tue, 27 May 2008 02:25 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
But export import will create the copy of schema.How will you propagate changes from one schema to another.This is not mirroring.
Re: Mirroring An Oracle Schema [message #323036 is a reply to message #323001] Tue, 27 May 2008 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you want an offline or online mirror?

Regards
Michel
Re: Mirroring An Oracle Schema [message #323037 is a reply to message #323033] Tue, 27 May 2008 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you want an up to date mirror, you have to use Streams.

Regards
Michel
Re: Mirroring An Oracle Schema [message #323042 is a reply to message #323037] Tue, 27 May 2008 02:58 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Dear Michel,

Thanks for replying.I wan't an online mirror.

can you please provide me the links for some tutorials related to this topic.

Regards,
Rajat Ratewal
Re: Mirroring An Oracle Schema [message #323053 is a reply to message #323042] Tue, 27 May 2008 03:43 Go to previous message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Start with reading the first chapter of Streams Concepts and Administration, then if you are interested with the other chapters and books on Streams.

Regards
Michel

Previous Topic: Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp
Next Topic: checkpoint and redo log files
Goto Forum:
  


Current Time: Mon Dec 05 11:06:25 CST 2016

Total time taken to generate the page: 0.05399 seconds