I have a 5GB oracle database that I want to export and then import on my own local database. Easy right?
The point is, I use oracle XE 10g which allows me to use up to 4GB. I then decided to make the export with the option "rows=N" and I would then fill my empty DB with what I need.
My export without any row is 1MB.
I created my user, granted privileges, created a 1GB tablespace and imported my 1MB file.
The problem is that the tables seem to have some pre-allocated space which means that my tablespace is still too small... 1GB space is too small for a 1MB dump, what a joke :/
I can't truncate the database, and I haven't found anything about turning off preallocation during either export or import.
How can I get this done?