Re: Importing to another user than the export was done from (Exp)
Date: Mon, 16 Oct 2000 16:49:01 GMT
Message-ID: <8sfbhr$mgi$1_at_nnrp1.deja.com>
Ulrik's method works fine ... if you're a DBA (or can convince the DBA to do it for you). If you aren't a DBA, you have to import into the old user's schema, then create an identical table under the new user's schema where you want the data, then insert into new schema's table by selecting from old schema's table, then drop the old schema's table.
In article <8semao$k6l37$1_at_ID-13717.news.cis.dfn.de>,
"Ulrik Hoffmann" <ulrik.peer_at_hoffmann-kiel.de> wrote:
>
> "Kim. Ammouche" <kim_at_ammouche.net> schrieb im Newsbeitrag
> news:MPG.1454f509d537d6ce989682_at_news.eltele.no...
> >
> > I am using IMP80 / EXP80 to move data.
> >
> > How can I import from a dump (dmp) file to another user than the
data
> > was exported from ?
>
> imp80 user/pwd_at_db file=yourexportfile fromuser=olduser touser=newuser
>
> hth,
>
> Uli
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Oct 16 2000 - 18:49:01 CEST