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

Thread: unable to extend

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    Hi friends,
    one of my database tables is partitioned into two partitions with the storage parameters initial 256k next 256k minextents 1 maxextents 505. The table partition(#2) is now full(I checked up with number of records and the records length). How to increase the storage without shutting down the database?
    Thanks
    manjunath

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    That table partition is on some datafile belonging to some tablespace right,

    Resize the datafile , increasing it.
    Also if the number of extents has also reached 505 , modify it to have unlimited as for now, but i would suggest to reorganize it, either using alter partition.. . move or alter table ...move, for which you will have to have some period of no access (only in 8.1.6 and above other wise no access for whole process at all) during the start and end of the process.

  3. #3
    Join Date
    Oct 2000
    Posts
    211
    thanks a lot gpsingh.
    So if I execute,

    alter table table_name modify
    storage(maxextents unlimited);

    Will the above be sufficient for the present? Also, the above will make both the partitions' storage parameters as unlimited, right?
    thanks
    manjunath

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