ORA-1632 max extents reached ..

Hi,

    i have an application where I create a tablespace , defaukt tablespace to a particular user .. The way I create this tablespace is

create tablespace ts_name

     datafile 'ts_path/ts_filename'
     size ts_size
     default storage (initial 5K next 5K pctincrease 50) ONLINE;

Now after using this for awhile populating thsi tablespace with tables and data, one particlaur table in this tablespace is giving me the error
ORA-1632 max extents reached ..

Now my questions are

1. How do I rectify this problem now on this existing tablespace
2. Is the method by which I create this tablespace potentially allowing this situation to occur ?
3. I checked the oracle cause and action on this error and it says recreate, can someone tell me how I can recreate this and still retain all my data, I am assuming create new tablepsace, , assign the same user to this default tablespace, what about the the data though ??? sorry of these questions are silly , just want to learn to do it right ...

Thanks
RSV
rsvcool_at_yahoo.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 09 1999 - 08:40:24 CDT