creating table with storage clause
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: creating table with storage clause

  1. #1
    Join Date
    Nov 2001
    Posts
    27
    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.

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    It is probably not a storage problem.

    Is it possible to publish the full create statement with columns?
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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 :-)




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width