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 :: Show Polls :: Message Navigator
E-mail to friend

Switch to threaded view of this topic

Create a new topic

Submit Reply

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

Send a private message to this user

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: 4381
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

Send a private message to this user

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

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

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: Wed Jun 19 10:43:40 CDT 2013

Total time taken to generate the page: 0.18361 seconds