Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ALL_TABLES

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US