Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database synch
A bit new to Oracle....
What do you think I should store in this log table? I want to monitor all 50 tables in my DB.
Primary key, Foreign Key, table name, status (modified, deleted, insert)
"Katherine" <ktlang_at_prodigy.com> wrote in message
news:5Psx8.184$9a7.174144788_at_newssvr13.news.prodigy.com...
> lucas:
> it is difficult to provide a specific answer without fully analyzing the
> application structure.
>
> however, look into creating triggers on the laptop to maintain log tables.
> each time a record is inserted, updated, or deleted, a record is inserted
in
> the log table, which identifies the change. then, write an application
that
> syncs the data between the master and laptop using these log tables.
>
>
>
>
> "Lucas" <Lucas_44_at_hotmail.com> wrote in message
> news:Pkfx8.7752$dd7.582549_at_news0.telusplanet.net...
> > Hi all,
> >
> > We have a system that the vendor downloads the current database from the
> > server to a laptop. Changes are made on his laptop, what is
> > the best way to upload this back to the server? Records are added,
> modified
> > and moved. Re-importing the whole database is not
> > an option.
> >
> > Lucas
> >
> >
>
>
Received on Wed Apr 24 2002 - 10:22:30 CDT