Re: Can I use replication (async) on a Partitioned Table(s)

From: jmnm <meirim_pt_at_hotmail.com>
Date: Thu, 24 May 2001 12:25:26 +0100
Message-ID: <9eirbm$8ej$1@venus.telepac.pt>

Thak you for your reply.

I'am already using async replication in an OLTP env. ( Oracle 7.3.4 ) What is the problem:

-I want to continue with the replication.
-I have a very large table.
-A problem with that table means  that I will have to stop a call center for

more than an hour and I need all the info(volume) online.

>>So to answer your question,
> >there is no logical reason why you cannot.

I Agree!.
But is there anyone who have tested/implemented ??

Regards

Jorge Meirim

"Michael Austin" <miaustin_at_bellsouth.net> wrote in message news:3B0C6CE5.12907B4B_at_bellsouth.net...
> Are you having a problem setting up the replication? Do you get an
> error? I would not implement any major feature of any database engine
> without first setting it up and hammering it in a development
> environment. Anything less is job suicide... do you have your resume
> ready?
>
> Replication should know nothing of the physical storage of the data. It
> merely takes what is read from the table and sends it to the remote
> database. It is the remote database engine that then takes the data and
> stores it in the physical table/tablespace. So to answer your question,
> there is no logical reason why you cannot. I have not had to set up
> replication from a partioned table in Oracle "Classic (7,8,9)" , so
> TEST, TEST TEST.
>
> Michael Austin
> DBA Consultant -- now available
>
> BTW, a good portion of the guts of partitioning code and algorithms came
> right out of Rdb which has had partitioned tables since approx. V3
> -circa '88-90' timeframe. I was glad to see V8 of Oracle "classic"
> finally get this feature as it is very useful in a VLDB environment.
>
>
> jmnm wrote:
>
> > Can I use replication (async) on a Partitioned Table(s).
> >
> > Do you know anyone using it ?
> >
> > Regards
> >
> > Jorge Meirim
>
Received on Thu May 24 2001 - 06:25:26 CDT