Re: Export/Import data thru pipe from prod to test server
- From: "tomac.yao@xxxxxxxxx" <tomac.yao@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 14 Feb 2007 08:29:31 +0800
hi:
please refer the following scripts.
exp tmp/tmp@rac file=/backup/oracle/imp_pipe log=exp.log &
$ORACLE_HOME/bin/imp tmp/tmp@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@xxxxxxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
