Re: show table parameters

On Thu, 25 Nov 2004 20:25:56 +0100, vertigo <ax178_at_wp.pl> wrote:

>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

Because table names are stored in uppercase in the dictionary. Lowercase characters are special characters. If you converted a Microsux table to Oracle, the tablename is in lower case and you need to enclose in double quotes.
For the rest of your way too elementary questions I strongly urge you to read the documentation, starting with the Oracle Concepts Manual.

--
Sybrand Bakker, Senior Oracle DBA