Home -> Usenet -> comp.databases.oracle -> Oracle Error Message!!!

Oracle Error Message!!!

From: Leader <sohelcsc_at_yahoo.com>
Date: 12 Sep 2002 01:58:06 -0700
Message-ID: <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
Received on Thu Sep 12 2002 - 10:58:06 CEST












Original text of this message