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
Received on Thu Sep 12 2002 - 10:58:06 CEST