Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 DBAReceived on Thu Nov 25 2004 - 13:39:13 CST