I have a dumpfile that I want to import in an Oracle 10g database in a virtual machine (with limited disk space). The dump file is about 3.5GB.
When I try to import the dump, the size of the
UNDOTBS01.DBF file explodes (up to 12GB – stopped because the disk was full).
I tried the following with no luck:
- lower the
- switch the
AUTORESIZEproperty of the
I read that the undo tablespace was used for flashbacks and rollbacks, I don't need any of these, I just want the data of the dump into the database.
What can I do?