Re: Oracle Error Message!!!

sohelcsc_at_yahoo.com (Leader) wrote in news:b1a93c73.0209120058.1e9fd383_at_posting.google.com:

> HI All,
>
> I am trying to create a table which i have given below. But Oracle
> gives me the below error message:::
>
> Syntax of my table creation::
> CREATE TABLE Expr_TBL(
> Expr_ID NUMBER(7),
> Expr_Name VARCHAR2(30),
> Expr_User VARCHAR2(1000),
> Expr_Sys VARCHAR2(1000),
> Var_name VARCHAR2(200),
> CONSTRAINT Expr_TBL_PK
> PRIMARY KEY(Expr_ID)
> using INDEX TABLESPACE INDX,
> CONSTRAINT expr_TBL_UK
> UNIQUE(expr_name))
> PCTFREE 10 PCTUSED 80
> STORAGE(INITIAL 20K NEXT 20K
> PCTINCREASE 0 MAXEXTENTS 75)
> TABLESPACE Tablespace_Name;
>
> Oracle's Error Message::
>
> unable to create INITIAL extent for segment in tablespace
> Tablespace_Name
>
> Can anyone please tell me what's the problem??
>
> Hoque
>

You don't have 20K contiguous free space within TABLESPACE_NAME. Received on Thu Sep 12 2002 - 14:11:06 CEST