Re: ** imp using multiple compressed exp dump files

> If the files xa* are compressed and you cat them,
> would compress -c not throw an error?

I think the OP compressed first and then split. So cat'ing them into one big (compressed) file is fine.

One little detail perhaps the OP can check is whenever you use a pipe, you don't want to accidentally drain the pipe. It's completely harmless to cat a regular file without any side effect. But if you cat a pipe when it's being used, whatever is stored in it is lost. This may happen when you repeat the work. For example, you want to go through your process one more time, but you forgot to start with a clean pipe. In this case, you should cat it (or recreate it), kill the writer process if it's still around.

I would also suggest using gzip instead of compress. Gzip seems to be more stable. And, insted of nohup (or screen), find a Windows box that has good uptime (e.g. a production server), run putty on it to your UNIX/Linux box. If your windows terminal session crashes, the putty process on the Windows box still runs.

Yong Huang       

--
http://www.freelists.org/webpage/oracle-l