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

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? Received on Fri Oct 07 2005 - 10:39:52 CDT