Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Lets make a list of problems with datapump
And how about the data pump transformations? REMAP_TABLESPACE
transformation?
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
>
>
>
-- Gabriel Hanauer -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 19 2006 - 07:36:29 CDT
![]() |
![]() |