IMP-00058: ORACLE error 1658 encountered on tablespace users -some pointers/advice needed

Question

IMP-00058: ORACLE error 1658 encountered on tablespace users -some pointers/advice needed

Resender

SSCertifiable

Points: 7443
More actions
August 3, 2011 at 5:46 am

#242545

I'm posting this here cause on the OTN-forum I'm getting nothing but grief and no real help.
I'm doing an import of quite a large database via a dmp file, one of the most frequent error is:
IMP-00058: ORACLE error 1658 encountered
ORA-01658:ORA-01658: unable to create INITIAL extent for segment in tablespace USERS.
I've looked up this error and increased the size of my users datafile (up to maxiumum blocksize possible),
still I'm getting this error.
Anyone can give me a tip on what to do.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 1

Resender (8/3/2011)
I'm posting this here cause on the OTN-forum I'm getting nothing but grief and no real help.
I'm doing an import of quite a large database via a dmp file, one of the most frequent error is:
IMP-00058: ORACLE error 1658 encountered
ORA-01658:ORA-01658: unable to create INITIAL extent for segment in tablespace USERS.
I've looked up this error and increased the size of my users datafile (up to maxiumum blocksize possible),
still I'm getting this error.
Anyone can give me a tip on what to do.

Problem is lack of space on USERS tablespace.

Not sure what you mean with "maximum blocksize", blocksize has nothing to do with how much you can extend a tablespace either by resizing/letting a specific datafile grow on demand OR adding a new datafile.

I'll suggest to check how much is Oracle intending to allocate for such table, do to this just run a import with show=yes and rows=no parameters... search log file looking for the specific table CREATE statement, there you will find how much space is Oracle intending to allocate as initial extent.

Hope this helps.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.