dial in and get data to our data warehouse

[callravi]

1.Basically we are starting a data warehousing company.
We had a central office.
2.That cetral office need to dial-in to the different remote client sites and get their data and store at our central ofice data warehouse through VPN .
3.Any one can tell me how can I accomplish this process .

 

[bigsacks]

Depends on if you need all data everytime or delta change data and the volumes etc etc.

I would consider using transportable tablespaces if your using oracle 8i but there are many ways to achieve this - export/import; scripts etc as I said need to understand the requirements alot more if help better.

 

[callravi]

Thnx for ur replly...

As u said we are currently studying our requirements.I will get back to u once i need any help.