Re: import

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Tue, 23 Mar 1999 19:42:43 -0800
Message-ID: <36F85F33.3052@oriolecorp.com>

Ed Lufker wrote:
>
> Hi All:
>
> I created a dump file as follows
> exp parfile = $parfiles/nightly_$1.par
>
> parfile looks like this:
> userid=system/manager_at_SDP1
> file=expdat_SDP1.dmp
> compress=n
> statistics=none
> owner=(wf,hst,sdp)
>
> QUESTION:
> What does the import command look like to import just these 3 users.
> I don't want sys or system.
>
> thanks in advance
> eddie lufker

imp cannot import anything but what is feed in ... as you have only exported your three users, your .dmp file contains only what you want. So the command you need is just

imp system/manage_at_SDP1 file=exp_SDP1.dmp full=Y log=imp_SDP1.log commit=Y

Beware that FULL has a different meaning for exp and imp : for exp it means all the database, for imp it means all the input file.

--
Regards,

  Stéphane Faroult
  Oriole Corporation

---

http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs

---

Received on Tue Mar 23 1999 - 21:42:43 CST