Re: question of user and tablespace

Try to revoke the system privilege 'UNLIMITED TABLESPACE' for the user:

REVOKE UNLIMITED TABLESPACE FROM myuser;

and then assign a quota on the "user1" tablespace for the given user:

ALTER USER myuser QUOTA UNLIMITED ON user1;

before the import.

Hope this help

Ciao Gennaro

leirace_at_my-deja.com wrote:

> Hi all,
> I have a user in oracle, "myuser",
> default tablespace is "user1", but many table use tablespace "user2"
> I want put all the table data into tablespace "user1".
> So , I export user "myuser", and recreate user "myuser" set default
> tablespace "user1", then import "myuser.dmp", but these table always
> in tablespace "user2".
> Please tell me how put all data into tablespace "user1" from "user2"?
> leirace
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Jul 26 1999 - 04:32:49 CDT