| ora-01536 when importing [message #439476] |
Sun, 17 January 2010 07:31  |
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  |
 |
Michel Cadot
Messages: 68645
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
