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)
The table that I am trying to created contains 31 colums.
My storage clause looks like this :
storage (initial 3M next 1M pctincrease 0)
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.
Click Here to Expand Forum to Full Width