Re: ALL_TABLES

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 25 Sep 1999 13:35:47 GMT
Message-ID: <37eccf50.556769@news.demon.nl>

Usually stuff like this is visible to the creator and dba-users only. To compare: the view all_segments doesn't exist, and the view all_users doesn't show tablespaces and (encrypted) passwords.

Hth,

Sybrand Bakker, Oracel DBA

On Sat, 25 Sep 1999 20:00:50 +0800, "Arati Vijay" <vijayj_at_singnet.com.sg> wrote:

>
>For tables created without specifying PCTFREE and
>PCTUSED, Oracle defaults them to 10 and 40 respectively.
>
>However, when I have a table with half a million rows (I have
>increased MAXEXTENTS using an ALTER TABLE), the
>PCTFREE, PCTUSED and MAXEXTENTS are not
>displayed in a query on ALL_TABLES. Any idea why?
>
>Regards,
>VJ
>
>
>
Received on Sat Sep 25 1999 - 08:35:47 CDT