Forum OpenACS Q&A: Response to Oracle import too slow?
have a script tar and gzip it up, and it sftp's the ora8.tar.gz file
over every day. Whenever I want to have a copy of the production
data, I just unzip and untar it. It seems to work just fine.
Caveat: Oracle has to be shut down while the copy is being
made on both ends. I'm on an Intranet, so that's not a big deal.