It seems your tablespace is realy badly fragmented! It is not sufficient to have enough free space in the datafile, this space has to be *contiguous*. Run the following query to see sizes of your free chunks in that tablespace:
select file_id, bytes as free_chunk from dba_free_space
where tablespace_name = 'USERS2'
order by bytes desc;
Try also coalescing adjascent free chunks in bigger chunks by
ALTER TABLESPACE ZSERS2 COALESCE;
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Have you tried by decreasing the initial extent value? But make sure that it is quite enough to hold the data. I faced the same problem , then I calculated the exact initial extent size required and it works.
you can import with rows=n
then alter the storage parameters, if you have many objects then you probably better build a script with dynamic sql to do the alter table/index etc etc.
after just import again with ignore=y