Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Export/Import

Re: Export/Import

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Tue, 24 Jul 2001 10:59:01 +0100
Message-ID: <995968737.8742.0.nnrp-07.c30bdde2@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.
Received on Tue Jul 24 2001 - 04:59:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US