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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 24 Jul 2001 22:12:12 +0200
Message-ID: <996005535.21854.0.pluto.d4ee154e@news.demon.nl>

"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

Original text of this message

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