Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Copy a schema without using EXP?

Re: Copy a schema without using EXP?

From: osy45 <member18536_at_dbforums.com>
Date: Sat, 01 Mar 2003 16:56:40 +0000
Message-ID: <2592208.1046537800@dbforums.com>

why not exp user/pwd_at_sid file=exp.dat

imp .... file=exp.dat fromuser= .. touser=---

or take the exp file imp it with the option show=y and pipe the results to a file and then modify all the user parameters using sed or your favourite editor

--
Posted via http://dbforums.com
Received on Sat Mar 01 2003 - 10:56:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US