Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Synchronization with Database on Laptops
In article <f7a191fc.0205140920.701472be_at_posting.google.com>,
r_benzinger_at_yahoo.de says...
>
>Hello Group!
>
>One of our customers has a Standard Edition production database and several
>laptops with Personal Edition installed. I have to write a script that
>periodically copies the new production data to the laptops. Until now I do it
>by hand using exp/imp but this is not an option for the future.
>
>8i Enterprise Edition has transportable tablespaces, which would be a natural
>choice, as I understand the docu. But that option is not available in Std Ed.
>My boss does not like the idea to tell them to upgrade their licence and pay a
>lot of money for this single feature (that he has already sold them ...).
>
>Do you know any acceptable alternatives or should I simply tell them to "eat
>the toad" (as we say here, no offence meant to Quest :-)
>
>Thanks,
>Robert
>
>PS: The server is Windows 2000, 8.1.7, the laptops are Windows '98, also 8.1.7.
There are a number of ways of doing what you want to do, but which is most suitable can't be determined with the information you've given so far. Here are some of your choices (the first two assume you may not have connectivity between the laptops and the main database at the time of refresh, the others assume you do):
Hmm, any others that I've missed guys?
HTH. Additions and corrections welcome.
Pete
SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Tue May 14 2002 - 13:58:08 CDT