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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Lets make a list of problems with datapump

Re: Lets make a list of problems with datapump

From: Ghassan Salem <salem.ghassan_at_gmail.com>
Date: Fri, 19 May 2006 10:18:15 +0200
Message-ID: <411d50f60605190118i70db56e4yec790c8a58875ca5@mail.gmail.com>


Well,
you have the option of doing 2 impdp sessions with exclude/include specified in order to do what you want.
rgds

On 5/18/06, Christo Kutrovsky <kutrovsky.oracle_at_gmail.com> wrote:
>
> You have table called BIGTABLE in tablespace USERS. You also have 500
> other tables in tablespace users. You take an export of that.
>
> Then when you import, you want bigtable to go in a separate
> tablespace. You cannot say "BIGTABLE goes into BIG_TBLSPC, the rest
> goes to users".
>
> And we're not talking about pre-creating objects and moving them
> arround before inserting.
>
> On 5/18/06, Alex Gorbachev <gorbyx_at_gmail.com> wrote:
> > Hi Christo,
> >
> > I didn't quite get these two:
> >
> > > - cant remap tables to tablespaces (i.e. table_name is in X
> tablespace
> > > with a number of other tables, and you want it imported into
> > > tablespace Y, but the other tables from X to go to X)
> >
> > > - schema-to-schema transfer only through loop-back dblink
> >
> > Could you elaborate please?
> >
> > Thanks.
> >
> > --
> > Best regards,
> > Alex Gorbachev
> >
> > http://oracloid.blogspot.com
> >
>
>
> --
> Christo Kutrovsky
> Senior Database/System Administrator
> The Pythian Group - www.pythian.com
> I blog at http://www.pythian.com/blogs/
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 19 2006 - 03:18:15 CDT

Original text of this message

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