error on maxextents in table...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: error on maxextents in table...

Hybrid View

  1. #1
    Join Date
    Jul 2002
    Posts
    228

    error on maxextents in table...

    hi,
    I created this tablespace:
    CREATE TABLESPACE TBS DATAFILE 'C:\....\XXX01.dbf' SIZE 500M REUSE DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 256 PCTINCREASE 0) ONLINE;

    When I try to insert a new record in table ST I get this error:

    ORA-01631:maxextents(256) reached in table TOM.ST

    I tried to increase maxextents: (user=system)
    ALTER TABLE TOM.ST STORAGE(MAXEXTENTS 500);

    but I get this error:
    ERROR at line 1:
    ORA-25150: ALTERING of extent parameters not permitted

    How can I resolve this error?
    Thanks
    Raf

  2. #2
    Join Date
    Apr 2003
    Posts
    353
    Alter table permission for you
    in that user ?

  3. #3
    Join Date
    Apr 2003
    Posts
    353
    Sorry .. mine is wrong

  4. #4
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    Determine the size of the table based on the rows you will have
    then REBUILD the table with the CORRECT storage parameters .. initial size and next extent size....

    HTH
    Gregg

  5. #5
    Join Date
    Feb 2004
    Location
    India
    Posts
    18
    U can have maxextents increased to Unlimited also but apply that if u require to.

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