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

• the orginal tablespace doesn't exist ---------> The user has no quota on the tablespace So to move a table by exp/imp make sure : the target tablespace is the default tablespace of the owner of the tables. This account doesn't have unlimited tablespace privilege, and doesn't have quota on the original tablespace.

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