Re: HELP!!!!!!!!!!

I can help but, you need to provide more data. I'll make some assumptions and try to give you enough info. so that you can better help yourself.

 These tablespaces you're attempting to create must have datafiles associated with them. How big are they? Let's assume your inserts will require 200M. If your datafile is 400M, then you have no problems with datafile limitations. Under the scenario you provided (10k x 10k), you will attempt to allocate more than 121 extents (approx 120M) and you will get the message you included in your request for help. In order to remedy this, there is one of two methods to employ. The preference would be to increase the INITIAL and NEXT extent sizes of your tablespace and/or tables. The other option requires that you change your database block size. This option would require that you recreate the database, therefore you may not find this option too appealing. the bottom line is that larger database blocks yield a higher max extents count.

Good Luck

-- 
Darryl Snedeker 		ph# (512) 602-2168
Senior Database Administrator	fax (512) 602-5018
Advanced Micro Devices		Austin, Texas