Re: EXP/IMP to a different tablespace: has anyone been able to solve this?

On Oct 23, 10:36 pm, arr..._at_inbox.com wrote:
> Followed all writeups I've read so far to come with the following:
>
> ----------------------------------------------
>
> alter user ${dest_schema} quota 0 on ${src_tablespace};
>
> alter user ${dest_schema} quota unlimited on ${dest_tablespace};
>
> imp file=${exp_file} ignore=Y fromuser=${src_schema} touser=$
> {dest_schema}
>
> ----------------------------------------------
>
> It does indeed create new objects in a new tablespace, but as soon as
> there's at least 1 row in the export file, it stubbornly attempts to
> go back to the src_tablepace (original user's tablespace data was
> exported from) and generates ORA-01536: space quota exceeded for
> tablespace error.
>
> Is there a clean solution, or each time I need to mess with renaming
> all tablespaces before imp and then renaming them back after imp?

IIRC, you have to set additionaly the default Tablespace for the destination User
(wont work for lob's)

regards

Stefan Kapitza Received on Thu Oct 25 2007 - 01:11:16 CDT