Re: ORA-1652: unable to extend temp segment by 512 in tablespace

On 8 Oct 2005 21:10:26 -0700, "suresh" <softgem_at_gmail.com> wrote:

>I granted unlimited tablespace access and was able to create the
>tables.
>
>GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO insite_adm identified
>by testing;
>
>I created 300 tables and the datafile grew to 1.5G, just for empty
>tables this much?
>
>I still don't understand how oracle allocates space and what's the best
>space allocation if I want to create a database with 300 tables?
>
>When I deleted the tables through drop table command the tablespace did
>not shrink, do I have to manually shrink the tablespace?

Tablespaces don't shrink automatically.
>
>Thanks for your reply, I am an amateur, trying to learn oracle

You would best try to read the Oracle Concepts manual for your version at http://tahiti.oracle.com

--
Sybrand Bakker, Senior Oracle DBA