DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Drop some segments of table ?

  1. #1
    Join Date
    Jun 2000
    Location
    Singapore
    Posts
    6

    Unhappy

    Hi Guru,

    A permanent object (table) is made up of many extents, so how can i drop some segments of the table ?

    Thanks

    Trandt


  2. #2
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    Talking

    You suppose not to go these way because a table can not be
    delete rows based on physical unit . :D


  3. #3
    Join Date
    Jun 2000
    Location
    Singapore
    Posts
    6
    Yes, so infact i lost a datafile hence a table on this one is lost also so in the dictionary still keep infomation about it, for this reason i want to drop directly some extents of that (update table uet$ & fet$ ) ?? and i don't want to ex-import this table (90G)

    Thanks.

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Depends on the version of the Oracle you are on.

    If it's 8.i you can rebuild your table online with new storage parameters. If it's realy big (90G, as you say) then I suppose finding sufficient free space for this will be a problem, I suppose. For such a big table partitioning is recomended anyway, if not for performance then definitively for managability - tasks like this you are facing now.

    If you are not on 8i yet (or even if you are) and you have a lot of free space above the highwattermark of this table (that is, a lot of unused space at *the end*) of that segment you can free this space with ALTER TABLE ... DEALOCATE UNUSED.

    Otherwise you have no other choice than to rebuild with exp/imp.

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Jan 2001
    Posts
    2
    jmodic's Idea is perfect !

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