Attempting to import 50GB+ dumpfile using impdp. Hitting the 11GB datafile limit. Never used oracle before. I created bigfile tablespace with autoextend on. Perhaps I should use different approach?

  • Which Oracle database are you using? A bigfile tablespace with 8K blocks can contain a 32 terabyte datafile. – JSapkota Aug 26 '16 at 12:54

Oracle XE has an 11GB data limit. You need to upgrade to Standard Edition.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.