Re: Synchronization with Database on Laptops

I do the same thing re updating a training Db on a laptop with the latest production data, as well as updating "test" databases with prod data.

I use the imp feature as I have each prod DB do a nightly export in addition to an online backup. I have it configured in scripts so all I have to do is run a "refresh_DBNAME.cmd" and let it run. The .cmd file opens up sqlplus, which creates and runs scripts to truncate all the tables, disable constraints and triggers, import the data from x user(s), then re enable constraints & triggers. Setting it up initially was a pain, but once it's done it's just a push-button operation to update the database.

I suppose you could accomplish the same thing by just copying the datafiles/redo logs/controlfile(s) from the last cold backup over to the laptop via scripts as well.

"Robert Benzinger" <r_benzinger_at_yahoo.de> wrote in message news:f7a191fc.0205140920.701472be_at_posting.google.com...
> 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. Received on Tue May 14 2002 - 12:42:03 CDT