Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Converting to large tablespace

    Currently we have tables and indexes in separate tablespaces. We're planning on converting the tablespace with the tables to large. Is it best practice, to also convert the tablespaces with the indexes to large also?

  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    I'm not sure what the best practice is but I would. Especially if the index tablespace is close to the max limit. Your data tablespace will be able to grow using the new limit so your index tablespace may need more space at some point too.

Posting Permissions

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