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

"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.