ora-01536 when importing [message #439476] |
Sun, 17 January 2010 07:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
goracle9
Messages: 136 Registered: December 2006
|
Senior Member |
|
|
Dear experts,
i have export file size 7.4 m(user-A) without rows, i need to import to user-B (tablespace having 7500m) free size 5500m
total segments size of user-A is 3726m, but i exported without rows giving 7.4m as mentioned yearlier.
if i import to user-B its saying
IMP-00003: ORACLE error 1536 encountered
ORA-01536: space quota exceeded for tablespace 'uaer-B'
why this is taking this mutch space, i dont have chance to collect extra space, but i need to import this file.
please give me solution urgent.
[Updated on: Sun, 17 January 2010 07:34] Report message to a moderator
|
|
|
Re: ora-01536 when importing [message #439477 is a reply to message #439476] |
Sun, 17 January 2010 08:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Try to first export with option "compress=n".
Now it also depends on your tablespace space management options.
Also check the following:
ORA-01536: space quota exceeded for tablespace '%s'
*Cause: The space quota for the segment owner in the tablespace has
been exhausted and the operation attempted the creation of a
new segment extent in the tablespace.
*Action: Either drop unnecessary objects in the tablespace to reclaim
space or have a privileged user increase the quota on this
tablespace for the segment owner.
Regards
Michel
|
|
|