Home » RDBMS Server » Server Utilities » ora-01536 when importing (oracle,Redhat Linux 4)
ora-01536 when importing [message #439476] Sun, 17 January 2010 07:31 Go to next message
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
Michel Cadot
Messages: 63912
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.

Previous Topic: sql loader
Next Topic: Import Schema
Goto Forum:

Current Time: Sun Oct 23 13:34:52 CDT 2016

Total time taken to generate the page: 0.16385 seconds