Re: replication or export ?

My understanding from your description is that in the database1 you produce documents and you want to "copy" those documents to database2. In addition, there is no network connection between database1 and database2.

If these documents have some attribute (e.g. an insert_date field and an update_field) that allows you to know when they were added or updated. Then you could do a create table as select .. in database1 where the records are not transfered yet. Then export that table. Copy the export file to the machine where database2 is and import. Once imported do an insert insert into mytable(.....fieldnames...) select ... fieldnames... from imported table.
Once done truncate the data in the imkported table. For updated records you will have to do an update not an insert.

Does that help?
Jim

"J.Dupont" <jdupont_at_yahoo.fr> wrote in message news:9u3oi7$309$1_at_wanadoo.fr...
> I have some problems with replication.
> I have 2 Data Bases (oracle 8.1.7 & IFS 1.1) on 2 sites. The first one is
> used by people who produce documents and the second one is used by
customers
> who needs to consult these datas. Once a month, I must add the new
documents
> (or the changed documents) to the 2nd Data Base. The 2 sites are not
> connected so I can't perform an on-line replication. I try to use
deployment
> templates but it doesn't work, I have problems with the offline
> instantiation. Is it possible to make an off-line replication ? What about
> export ? I don't want to export all datas each time, I only want to export
> useful datas. I need some help and some docs about this topic
(replication,
> export, deployment templates,...). I have already read the Oracle8i online
> doc, but it doesn't help me much.
> Thanks in advance.
> J. Dupont
>
>
Received on Wed Nov 28 2001 - 17:15:54 CST