Good morning DBAs,

A colleague has created a table in a locally managed tablespace in an . In
the DDL she has specific pctfree 5, pctused 85, freelists 1, freegroups 1.
The DDL appears to be syntactically correct since it does create the table.

However, when querying the dba_tables view for the table it shows the
pctfree value but null pctused, freelists and freegroups value.

Could this be an LMT thing?

Can anyone explain why?

Thanks...
Steve



This communication, including attachments, is for the exclusive use of
addressee and may contain proprietary, confidential or privileged
information. If you are not the intended recipient, any use, copying,
disclosure, dissemination or distribution is strictly prohibited. If
you are not the intended recipient, please notify the sender
immediately by return email and delete this communication and destroy all copies.


Oracle LazyDBA home page