Re: Lets make a list of problems with datapump

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