Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle exp imp
hello,
could you give the parfiles or paramteres you user for both exp and imp. Do want to (re)create tables in t2 schema aor do they already exist ?
"hpuxrac" <johnbhurley_at_sbcglobal.net> hat geschrieben:
>
> Piotr wrote:
> > Hi
> >
> > I have problem with importing data to different tablespace
> > Oracle 10g on red hat 4 es
> > I've exported data from user t1 with full = y
> > I have to import data to user t2 - his tablespaces are named differenlty
> > than t1.
> > Is it possible?
>
> Have you tried fromuser with touser?
>
> What error messages are you receiving?
>
> Data pump should be able to do this easily.
>
Received on Mon Nov 20 2006 - 10:39:15 CST