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

Another way to do the same:
If you set the IGNORE-parameter (IGNORE=Y) in your import-parfile, you could precreate the whole scheme in the other tablespace. Then the DDL-statements in your export will be ignored (though firing a warning).

regards,
Marc Staudacher

"Peter Kroiss" <pk_at_faw.uni-linz.ac.at> wrote in message news:3a33d96d_at_alijku02.edvz.uni-linz.ac.at...
> 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 Mon Dec 11 2000 - 15:05:41 CST