Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export/Import
"Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> wrote in message
news:9jjit2$l18$1_at_news247.cnt.ru...
> Hello!
> See original question!
>
> Yaroslav.
>
> andrew_webby at hotmail <spam_at_no.thanks.com> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ
> ÓÌÅÄÕÀÝÅÅ:995968737.8742.0.nnrp-07.c30bdde2_at_news.demon.co.uk...
> > But now the table is owned by a different schema.
> >
> > As Erwin said, all he has to do is create the table layout with the new
TS
> > first, then run the import.
> >
> > "Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> wrote in message
> > news:9jjdja$k45$1_at_news247.cnt.ru...
> > > Hello!
> > >
> > > Erwin Dondorp <erwindon_at_wxs.nl> ñîîáùèë â íîâîñòÿõ
> > > ñëåäóþùåå:3B5D33F5.C32D5D35_at_wxs.nl...
> > > > Yaroslav Perventsev wrote:
<snip>
> > > imp user2/test_at_db2 file=user1.dmp fromuser=user1 touser=user2
> > >
> > > Import successful imported test table into tablespace ts2 of user2;
> > >
> > > What wrong?!
> > >
> > > Best regards!
> > > Yaroslav.
> >
> >
> >
>
>
Import imports in
a) the tablespace of the create tablespace
b) the default tablespace if
Sorry to say so, but all answers were incomplete.
Regards,
Sybrand Bakker, Senior Oracle DBA Received on Tue Jul 24 2001 - 15:12:12 CDT
![]() |
![]() |