Hi All,

I am using Locally managed tablespaces in Oracle 8i (64 Bit) / Solaris (64 Bit) environment.

What should be the max size of datafiles allocated to a locally managed tablespace. Currently I hv tekpt them in Autoextend Mode. But I need to keep a check on the size so that I may not end up into problems later.

This is for our DW project.

Please help me understand.

Could anyone point me to some good article about Locally Managed Tablespaces....