Re: Problems on copying a database user from one tablespace to another on the same instance

Peter,

Make sure that NEW USER does have UNLIMITED TABLESPACE privilege, if NEW USER does, then revoke it.

Grant NEW USER a quota on the default tablespace, and it should work.

Chris

Peter Kroiss wrote:
>
> I tried to export a user with
> BUFFER=8192
> FILE=G:\export.dmp
> COMPRESS=Y
> GRANTS=Y
> INDEXES=Y
> ROWS=Y
> CONSTRAINTS=Y
> LOG=G:\export.log
> OWNER=(USER1)
> RECORDLENGTH=8192
>
> and then reimport the data into a new user on a new tablespace with
> BUFFER=8192
> FILE=G:\export.dmp
> SHOW=N
> IGNORE=N
> GRANTS=N
> INDEXES=N
> ROWS=Y
> LOG=g:\import.log
> DESTROY=N
> FULL=N
> FROMUSER=(USER1)
> TOUSER=(NEWUSER)
> RECORDLENGTH=8192
> COMMIT=N
>
> The problem is that the import always creates the tables in the the
> tablespace from user1 and not in the default-tablespace
> of the new user (NEWUSER).
>
> Peter
Received on Sun Dec 10 2000 - 13:58:58 CST