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

jmnm wrote:

> 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 ??
>

All I can say is that you need to test this in YOUR environment. It should work, but you will only know if you try. (get 2 samll PC's running Solaris or Linux, install, and test) You should have a development environment where you can do this. If not, then I question the abilities of your management.

>
> 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 - 09:56:30 CDT