I have a tablespace called (Users) and the datafile that is associated to it is /users01.dbf.

when I created this tablespace, I had orignally assigned a disk space of 200m with next exent of 1mb and max of 121, I think.

Here's the thing, on monday I will need to load a 2gig data into my box for a user, who's default tablespace is (Users)

Will I be running into any problem?

should I have auto extents turn on and set growth rate to unlimited?

I'm totally lost on how this stuff works.


thanks in advanced.