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@xxxxxxxxx> 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/
--
//www.freelists.org/webpage/oracle-l
