Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: replication or export ?
news <kennedy-family_at_home.com> a écrit dans le message :
KeeN7.89758$XJ4.49231199_at_news1.sttln1.wa.home.com...
> 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.
>
In fact I do not only "copy" document. On the main DB, I can delete
documents, add properties, add classes,... So I want to affect these changes
to the the second DB. I read some papers about replication, export/import,
offline instantiation, transportable tablespaces, but I don't understantd
all these "concepts". Do you have any information about it ? Then, can you
know oracle forums on the internet ?
Thanks in advance.
Jérôme
> 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
>
Received on Fri Nov 30 2001 - 06:24:02 CST