Check DBA_TABLESPACES --> SEGMENT_SPACE_MANAGEMENT

If this column is set to AUTOMATIC (which is only available if it is a
LMT) then it does not use Freelists, Freegroups or Pctused.



Thanks...
Chris


Oracle Engineering
[Email address protected]
224.405.0368




"Haas Steven (CLAIM Claims) "
<oracledba-ezmlmshield-x46949311.[Email address protected]
06/30/04 08:36 AM


To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: PCTFREE / PCTUSED


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.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page