Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    California
    Posts
    1

    Unanswered: Deframenting Segments for a table

    Hi,
    We have a very big table that keeps millions of records and this table has 4 segments allocated to that table. Recently we were getting a critical error when ever we logon to the client saying that 3 segments were more than 95% filled up. So we deleted lot of rows from this table to solve the space issue. Even though the percentage is not increasing any more, we are still getting this critical error message. Informis is using the deleted space but database itself is not able to see this space. How can I defragment the segments in order for the database to see this space and get rid of the critical error message ??

    Thanks in advance.

    Thanks,
    Raja.

  2. #2
    Join Date
    Mar 2003
    Location
    Germany
    Posts
    10
    Dear Raja,
    we had a similar problem with one of our tables. If I remember right, it is not possible to re-use the old segment by deleting some rows.

    So we created totaly new dbspaces for the different fragments and altered the table, e.g.

    alter fragment on table xxx init
    fragment by expression
    (column1= "expression1") in dbspace1,
    (column1= "expression2") in dbspace2,
    ...
    remainder in dbspace8;

    In our case we used expression based fragments, also possible is the round-robin-fragment. What makes sense depends on your data.

    I'm not sure if this is the best solution, but it worked fine.

    Good Luck
    Regina

  3. #3
    Join Date
    Jul 2003
    Location
    Calcutta, India
    Posts
    42
    U can also check this out

    1. Delete all the index on the tables and recreate it once more.

    I think this will help you.

    Thanks
    adityanlal

Posting Permissions

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