Re: wt are different ways in oracle for data transporting/transfereing

"Andreas Sheriff" <spamcontrol_at_iion.com> wrote in message news:2okHe.6239$Tr6.1939_at_lakeread02...
> "shahsyed" <shahsyed_at_gmail.com> wrote in message
> news:1122880811.714371.114020_at_o13g2000cwo.googlegroups.com...
>> Wt are ways in oralce for data transfering between oracle databases
>> of same version or different
>>
>> scenerio#1
>> 1)4 databases runninge oracle 9i
>> 2)not connected means not online/or on the network
>> 3)one of database server is considered to master database
>> 4)Dataupdation frequency on master database server from other 3
>> databases will be twice or less in week.
>>
>
> If your servers were on a network I would say consider replication.
>
> Barring that, you can use imp (import) / exp (export), putting the data on
> cd(s)/dvd(s)/tape(s), or whatever physical means you wish to use for
> transfer. Make sure, though, that you add an extra column to each of your
> tables to identify the server where your data is being imported from so
> that
> you don't have conflicts, and implement a conflict resolution algorithm to
> normalize the added column so that you can select clean, referential data.
> Note: This is a hack because your databases are not connected.
>
> I would highly suggest you connect your databases over a network, and use
> replication.
>
> --
>
> Andreas Sheriff
> Oracle 9i Certified Professional
> Oracle 10g Certified Professional
> Oracle 9i Certified PL/SQL Developer
> ----
> "If you don't eat your meat, you cannot have any pudding.
> "How can you have any pudding, if you don't eat your meat?"
>
> DO NOT REPLY TO THIS EMAIL
> Reply only to the group.
>
>

If they are within the same network, you could also use transportable tablespaces.

Matthias Received on Tue Aug 02 2005 - 04:56:41 CDT