| big problem face me [message #290034] |
Thu, 27 December 2007 03:48  |
mohamed99
Messages: 8
Registered: December 2007
Location: united arab emirates
|
Junior Member |
|
|
Dear Friends,
now i desigin to do one project for barcode system ,i complete my desigin here but i have one problem facing me this problem is Updation (how can i do updation to our branches and we have 11 branches and decide to do updatiion for all branches offline ,please desccribe how can i solve this problem....???
|
|
|
|
|
|
|
|
| Re: big problem face me [message #290125 is a reply to message #290122] |
Thu, 27 December 2007 10:29  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
So, the main problem is how to get data from remote areas to your place. Right?
Does it mean that every point of sale runs its own Oracle database? How do you communicate with them? Dial-up, not at all, or something different?
As I understood it, there's no connection between you and those 11 POSes. The only way I can think of is to make an export of desired tables and mail them to you. If your database version supports it, you might try with a conditional export (using the WHERE clause, for example EXP un/pw@db tables=sale query="where date_column > trunc(sysdate)"). Once you have those exports, import them into your database and run the report.
On the other hand, if there IS a connection there, you might create materialized views which would refresh periodically (or on demand) and get data to you. Or, you might even directly access data via a database link.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
