OraFAQ Forum: Server Administration » Mirroring An Oracle Schema

Home » RDBMS Server » Server Administration » Mirroring An Oracle Schema (Oracle 9i,9.2.0.6.0 Windows XP)

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

Mirroring An Oracle Schema [message #323001]

Tue, 27 May 2008 00:55

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

Report message to a moderator

Re: Mirroring An Oracle Schema [message #323023 is a reply to message #323001]

Tue, 27 May 2008 02:02

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.

Report message to a moderator

Re: Mirroring An Oracle Schema [message #323033 is a reply to message #323023]

Tue, 27 May 2008 02:25

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.

Report message to a moderator

Re: Mirroring An Oracle Schema [message #323036 is a reply to message #323001]

Tue, 27 May 2008 02:34

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do you want an offline or online mirror?

Regards
Michel

Report message to a moderator

Re: Mirroring An Oracle Schema [message #323037 is a reply to message #323033]

Tue, 27 May 2008 02:35

Michel Cadot
Messages: 68675
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

Report message to a moderator

Re: Mirroring An Oracle Schema [message #323042 is a reply to message #323037]

Tue, 27 May 2008 02:58

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

Report message to a moderator

Re: Mirroring An Oracle Schema [message #323053 is a reply to message #323042]

Tue, 27 May 2008 03:43

Michel Cadot
Messages: 68675
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 06 13:58:40 CDT 2024