Are there problems with locally managed tablespaces ?

[parbhani]

Hi all,

I am still in 8.1.7, but will be soon going to 9.2 .
I want to know experiances of people.
Theoratically we can say, locally managed tablespaces are very good, there are many advantages, specially when we make them autoextend.

I want to know if somebody has faced any problems with locally managed tablespaces, which may have been avoided if they were dictionary managed or which may have beed avoided if they were not extending automatically.

Which will eventually give us a list of precautions we should take when we use these.

Regards

 

[SantaMufasa]

Parbhani,

We have been successfully using locally managed tablespaces for years, since Oracle 8i. We have had nothing but great success with them and not a single occurrence of an unsavory incident. I recommend them highly and have not created a dictionary tablespace for applications since their inception. Use them to good health .

Mufasa
(aka Dave of Sandy, Utah, USA @ 19:12 (11May04) UTC (aka "GMT" and "Zulu"), 12:12 (11May04) Mountain Time)