Re: can't import to default tablespace

Hi Ed,

This is a common problem.
There are two ways to prevent this:
1 make sure tablespace_a doesn't exist, and of course in many cases this is not feasible.
2 make sure the user has quota on tablespace_b only. If your user has the resource role, he will automatically have unlimited tablespace which allow for unlimited table creation in ALL tablespaces. You need at least to revoke the unlimited tablespace privilege. Then you need to give quota on tablespace_b by alter user quota unlimited on tablespace_b.

This should resolve it.

Hth,

Sybrand Bakker, Oracle DBA
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:51:52 CDT