Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXP/IMP to a different tablespace: has anyone been able to solve this?
On 23 Okt., 22:36, 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?
in datapump an option? 10G maybe? Received on Wed Oct 24 2007 - 01:55:25 CDT
![]() |
![]() |