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

suresh wrote:
> I created a database called desksite and a user as
>
> create user insite_adm identified by testing
> grant CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM to
> insite_adm;
>
>
> create tablespace insite
> datafile 'E:\oracle\oradata\insite\insite_data.dbf'
> size 100M
> extent management local uniform size 4M
>
>
> CREATE TABLE insite_adm.account (
> account_id varchar2 (24) NOT NULL,
> supplier_code varchar2 (4) NOT NULL,
> name varchar2 (100) NOT NULL,
> account_code varchar2 (100) NOT NULL,
> description varchar2 (1000) NOT NULL,
> active_flag number(1) NOT NULL
> )
> ;
>
> CREATE TABLE insite_adm.account_site (
> account_id varchar2 (24) NOT NULL,
> site_id varchar2 (24) NOT NULL
> )
> ;
>
> First table gets created and looks like it takes all the space,
> because when I look at user_segments; I get
>
> segment_name|tablespace_name|bytes|blocks|extents|initial_extent|pct_increase|freelists
> ACCOUNT|INSITE|4194304|512|1|4194304|0|1
>
>
> I am getting this error when I try to create tables from insite_adm,
>
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> INSITE
>
>
> Please anyone can help me?

I'm not sure what the point was in creating a 4MB tablespace. Create a 100M tablespace and see what happens. My guess is that you will still get a 4MB initial extent.

But definitely patch to 9.2.0.6 before you proceed.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)