Forum OpenACS Q&A: Response to Oracle import too slow?

Collapse
Posted by Jade Rubick on
Andrew, what I do is just copy across the entire /ora8 directory. I
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.