1

I'm trying to import a large database, and after a while I get:

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

I know this has been asked before, but I can't find a clear answer other than "increase the size".

Tablespace is like this:

Tablespace

It's an autoextend, but that is meaningless since it can't grow past 32GB, therefore I can't "increase the size".

Does impdp try to do everything in one transaction?

I don't care what it's putting in UNDOTBS1, if I lost everything in there that would be fine, I just want the import to run successfully.

Can I flush it out?, Is there an impdp option that I can use to make it not crash after 2 hours of hoping it won't crash?

There is plenty of disk space.

Any advice appreciated

6
  • 1
    If there's "plenty of disk space", why is it that the tablespace "can't grow past 32GB"?
    – mustaccio
    Jun 22 at 17:38
  • 1
    Have you seen this?
    – mustaccio
    Jun 22 at 17:42
  • @mustaccio because of the overall poor quality of the software: community.oracle.com/tech/developers/discussion/975815/… "even if you have a datafile set to autoextend, it is limited to 2^22 blocks in size. At an 8k block size, this means 32GB"
    – Jobbo
    Jun 23 at 10:12
  • A tablespace defined as a BIGFILE (or single file) tablespace can have a datafile as large as 128TB depending on support of the underlying OS or storage. That said, if the link provided by @mustaccio doesn't help (and it sounds like it should help), the answer to growing a tablespace limited to 32GB per file is simply to add another file using the ALTER TABLESPACE command.
    – pmdba
    Jun 23 at 10:47
  • are you importing into existing tables?
    – miracle173
    Jun 23 at 12:35

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.