Re: Export/Import data thru pipe from prod to test server

hi:
please refer the following scripts.

exp tmp/tmp_at_rac file=/backup/oracle/imp_pipe log=exp.log & $ORACLE_HOME/bin/imp tmp/tmp_at_ractest file=/backup/oracle/imp_pipe fromuser=tmp touser=tmp grants=n ignore=y rows=n log=/backup/oracle/imp.log

On 13/02/07, DIANNA GIBBS <DIANNA.GIBBS_at_childrens.com> wrote:
>
>
> We're AIX 5.2 Oracle 9206 and need to export data from prod to our test
> instance for refresh.
>
> I thought I had read where I could use pipes and export/move data to
> test box/import all at the
> same time thus eliminating disk space for the export file.
>
> Any thoughts for doing this? Thanks.
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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