The export records the tablespace the table was created in. Only when that
tablespace doesn't exist in the destination database will the user's default
tablespace be used.
--
Terry Dykstra
Canadian Forest Oil Ltd.
ewong74_at_netscape.net wrote in message <7eatnp$3t5$1_at_nnrp1.dejanews.com>...
>Hi there,
>
>I tried to do an export from 1 machine then import to another machine but
the
>import did not go to the user's default tablespace. What I did was:
>
>export tables of user_A from machine_A default tablespace_A:
>exp system/manager file=exp.dmp tables=user_A.table1...
>On machine_B, I created user_A default tablespace_B then I do an import:
>imp system/manager fromuser=user_A touser=user_A file=...
>
>And the import goes directly into tablespace_A(it was there before) instead
of
>default tablespace_B.
>
>What happen? Many thanks.
>
>Ed
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Apr 05 1999 - 13:53:43 CDT
