Disadvantages of Transportable Tablespaces??

[nirasha]

We have just changed some of our tablespaces to locally mannaged tablespaces, so that they can be trasportable in import/export commands.

Even if they do well, before implementing I would like to know if anyone out there knows any disadvantages of this.

Thanks in advance,
Nirasha

[rcaballe]

I have 4 months with them and I have not found any problem.
But don't use it in Rollback segment tablespace. (There are bugs)
And even I'm using it in TEMP tablespaces too, I'm not sure if Oracle manages that well, I guess I'm hitting some bugs with temporary tables in temporary tablespaces :(

[nirasha]

Thanks for your reply. If they are locally managed, should I be looking out for anything??

Thanks,
Nirasha

[rcaballe]

Yes.
If you put it Automatic allocation, you should check what tables/indexes are getting bigger, not because any problem, just to separate them to another tablespace (TBS1_BIG_DATA) or something, it's not necessary just more beauty :).
If you put it Uniform you should check if you don't overestimate some table, this you can know seeing blocks free after an analyze.
Again, you can create 3 tablespaces in uniform:
Extent:
128K=>Small tables
4M=>Medium tables
128M=>Big tables
Hope it helps.
You can find these in a doc called "How stop defragmenting...."

[nirasha]

Thanks alot.

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