Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export/Import
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.
Received on Tue Jul 24 2001 - 04:59:01 CDT