Re: Import errors on 8.1.6

"Diana Fernandez" <dianaf_at_meta4.es> wrote in message news:9g83p8$d4d$1_at_diana.bcn.ttd.net...
> Hi, I', trying to import data from a different user (with the
 FROMUSER -
> TOUSER arguments) with the Oracle 8.1.6 IMP tool. Both users are in the
 same
> Oracle 8.1.6 server, the destination user is empty.
> The IMP tool seems to have a couple of bugs, it makes a mess with the
> names of the tablespaces: it tries to use the old one (the tablespace used
> by the FROMUSER user) instead of the new one (the one used by the TOUSER
> user) in these cases: on creating the constraints and on allocating new
> extents from the tables with CLOB fields.
> ¿Is there any way to workaroud this problem other than manually create
> the destination objects with SQL creation scripts (CREATE TABLE, ADD
> CONSTRAINT...)? I know the INDEXFILE option, but wouldn't like to use it
 if
> not necessary. ¿Can I use any other tool that works properly, or any other
> IMP version?
>
> Thanks and regards.
>
>

IMP is working as designed. It was not designed a tablespace move automatically.
You need to revoke unlimited tablespace privilege from the destination user You need to
alter user <target_user> quota unlimited on <target_tablespace> and
alter user <target_user> default tablespace <target_tablespace> to get around this.
Obviously, this has been posted many times.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Jun 13 2001 - 11:53:35 CDT