Unanswered: ora-1659: Unable to allocate MINEXTENTS beyond 9 in tablespace
I am trying to import data from exp file. but i am getting ora-1659: Unable to allocate MINEXTENTS beyond 9 in tablespace QMS2(my tablespace name).
I tried to extend the space of the table by adding datafile but it didn't help. I found out that this might be because of coelscing (space fragmentation). I dropped all the object in my tablespace and tried to import again, but I am still getting the same error. Could someone guide me as how to overcome the coelscing problem.