-
I am trying to create a table using a storage clause but I am getting an Oracle SP2-0027
SP2-0027: Input is too long (> 2499 characters)
I have created a tablespace for my database:
CREATE TABLESPACE WHATEVER
DATAFILE '/usr/local/.. /WHATEVER.dbf'
SIZE 200M REUSE
DEFAULT STORAGE (INITIAL 25M NEXT 25M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0)
PERMANENT;
The table that I am trying to created contains 31 colums.
My storage clause looks like this :
storage (initial 3M next 1M pctincrease 0)
tablespace WHATEVER;
I have also tried to alter my tablespace to have the AUTOEXTEND option turned ON.
Also, this may be very important to note:
When I create the tablespace with 30 columns, instead of 31, I can create the table.
Can anyone please help me? Thank you.
-
It is probably not a storage problem.
Is it possible to publish the full create statement with columns?
-
I did create the tablespace the same way you defined it:
SQL> CREATE TABLESPACE WHATEVER
DATAFILE '/home4/user40/ORADATA/u01/WHATEVER.dbf'
SIZE 200M REUSE
DEFAULT STORAGE (INITIAL 25M NEXT 25M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCRE
ASE 0)
PERMANENT;
Tablespace created.
Then I created a table with 31 columns:
SQL> create table aaa(
x00 date,x01 date,x02 date,x03 date,x04 date,
x05 date,x06 date,x07 date,x08 date,x09 date,
x10 date,x11 date,x12 date,x13 date,x14 date,
x15 date,x16 date,x17 date,x18 date,x19 date,
x20 date,x21 date,x22 date,x23 date,x24 date,
x25 date,x26 date,x27 date,x28 date,x29 date,
x30 date,x31 date
)
storage (initial 3M next 1M pctincrease 0)
tablespace WHATEVER;
Table created.
SQL>
What error do you get?
Could it be a quota/restriction problem?
When you said "When I create the tablespace with 30 columns, instead of 31, I can create the table. ", I assume you meant table, not tablespace :-)