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

On Tue, 23 Oct 2007 13:36:02 -0700, array7_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?

Never seen this, and as your post is pretty scarce on details (no version, no information about how the user where set up (they don't have unlimited tablespace privilege, do they) no command line) it boils down to
It doesn't work
and requires a crystall ball
Provide more details or precreate all objects, whatever you prefer.

-- 
Sybrand Bakker
Senior Oracle DBA