Re: Export/Import

From: Zeyad S <sweidanz_at_yahoo.com>
Date: Wed, 25 Jul 2001 09:38:58 +1000
Message-ID: <3B5E0711.D848A6FE@yahoo.com>

Thanks Sybrand, that makes it clear.

Thanks all,
ZS

Sybrand Bakker wrote:

> "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 - 18:38:58 CDT