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: show table parameters

Re: show table parameters

From: Dave <x_at_x.com>
Date: Thu, 25 Nov 2004 19:40:10 GMT
Message-ID: <uyqpd.22953$up1.2413@text.news.blueyonder.co.uk>

"vertigo" <ax178_at_wp.pl> wrote in message news:co5bon$cjo$1_at_atlantis.news.tpi.pl...
> Hello
> How can i check table parameters (it's actual size, and storage parameters
> such as PCTINCREASE ...) ?
>
> I tried to find my table:
> select * from dba_tables where table_name='test' but did not find, why ?
>
> Thanx
> Michal
>

select * from dba_tables where table_name='TEST';

upper case table name Received on Thu Nov 25 2004 - 13:40:10 CST

Original text of this message

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