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

Thread: Local Tablespaces

  1. #1
    Join Date
    Nov 2000

    I was under the impression that a tablespace had to be locally managed to be able to transport them. Upon reading the document on (8i Central) Transportable tablespaces and Locally managed tablespaces, I could see no correllation.

    Am I missing something? I was told that the tablespaces had to be locally managed to be transportable. Is this true?


  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    What you read was correct. The locally managed tablespaces are primarily for efficiency. i.e to avoid searching the data dictonary to find the schema, which was said to consume time. In turn making a table space locally managed, it would have its own bitmap index on the nodes and the performance becomes more efficient. The Tran TBL, are used to move the table spaces between the instances.


    Life is a journey, not a destination!

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