Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: 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
    Feb 2004
    Posts
    4
    Hi,
    Did u give any storage specifications while creating table. I f u dint specify, the default values are the tablespace's extent specifications. Try to alter the maxextents of tablespace.
    Anitha

  3. #3
    Join Date
    May 2003
    Location
    France
    Posts
    112
    Hi,

    if your tablespace has been created with autoallocate, you can't modifiy table's extents.

  4. #4
    Join Date
    Jul 2002
    Posts
    227
    Originally posted by ndu35
    Hi,

    if your tablespace has been created with autoallocate, you can't modifiy table's extents.
    if I can't modify table's extents, how can I insert a new record in my table?

  5. #5
    Join Date
    May 2003
    Location
    France
    Posts
    112
    is your tablespace full ? check dba_free_space

    Originally posted by raf
    if I can't modify table's extents, how can I insert a new record in my table?

  6. #6
    Join Date
    Jul 2002
    Posts
    227
    I RUN THIS QUERY:

    select *
    from dba_segments
    wHere owner='TOM'
    AND SEGMENT_NAME='TS'

    and I get these values:

    OWNER=TOM
    SEGMENT_TYPE=TS
    TABLESPACE_NAME=TBS
    BYTES=5980160
    BLOCKS=730
    EXTENTS=256
    INITIAL_EXTENT=1802240
    NEXT_EXTENT=16384
    MIN_EXTENTS=1
    MAX_EXTENTS=256
    PCT_INCREASE=0

    Have you any idea?

  7. #7
    Join Date
    May 2003
    Location
    France
    Posts
    112
    select * from dba_tablespaces where tablespace_name='tbs'
    check allocation_type

    select max(bytes) from dba_free_space where tablespace_name ='tbs'
    max must be > 16384

Posting Permissions

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