OraFAQ Forum: Replication » What is the best way to replicate the data?

Home » Server Options » Replication » What is the best way to replicate the data?

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

What is the best way to replicate the data? [message #75442]

Mon, 05 January 2004 09:58

Jadie
Messages: 64
Registered: January 2002

Member

I want to replicate some data from the production database to another database using by Marketing department. These data will be selected from some tables that meet some selection criterias.

Can anyone tell me what is the best way to do it? Appreciate any response!!! Thanks.

Jadie

Report message to a moderator

Re: What is the best way to replicate the data? [message #75444 is a reply to message #75442]

Tue, 06 January 2004 01:53

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

You can use a Materialized View (Snapshot).

Look-up the "CREATE MATERIALIZED VIEW" statement in the SQL Reference Guide.

Best regards.

Frank

Report message to a moderator

Re: What is the best way to replicate the data? [message #75525 is a reply to message #75444]

Wed, 28 July 2004 02:45

M.werasinghe
Messages: 1
Registered: July 2004

Junior Member

i want to sent some data over the dial-up connection
by using SQL server 2000 if someone know about that place inform it

Report message to a moderator

Previous Topic:	Materialized views
Next Topic:	why I use sqlplus internal, but the system ask me the passwd?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 04 01:48:39 CST 2025