-
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?
Thanks
Nirasha
-
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.
Sam