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

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?

Thanks for your reply, I am an amateur, trying to learn oracle Received on Sat Oct 08 2005 - 23:10:26 CDT